data cleaning

[Ksharp]

Use FIND() function.

If find(Qu_8 ,'Highschool') or find(Qu_8 ,'1') then Qu_8 ='High school/ Secondary School';

Else if find(Qu_8 , ' Master')  then Qu_8 = 'Master Degree';

Else if Qu_8 ='.';

[tuntun]

Thank you so much, it's solved

[VDD · Accepted solution]

If it is solved them please select the response that assist in solving your request.

Help the community by closing the thread.

[tuntun]

how to delete my question?