Log In
Register
Home
Active Member
December 4, 2019
Offline
Hi,
I have started to work on a huge data, where some cells contain non english words, is there a way to remove rows where a cell contains non english words.
Thanks.
VIP
Trusted Members
June 25, 2016
Offline
Hi Leeroy
It would help if you can attach some sample data so that we can have a look at it.
No idea what you meant by non-English words.
(1) Is it foreign language such as Arabic ٱلْأَبْجَدِيَّة ٱلْعَرَ, Mandarin 北方话, Korean우리말etc?
I can only think of using CODE(). It will give 63 in all of the cases.
(2) Or non-English words such as adios, hola etc (spelt using alphabet)?
No idea how to do this in Excel but you can try Googlesheets using the DETECTLANGUAGE() function. (Yes, I know this is an Excel forum 
)
It will return a language code such as zh, en, es etc. where en=English. It will also work for (1) above.
Hope this helps.
Sunny
Active Member
December 4, 2019
Offline
Hi sunny,
Thank you for your response,
I have attached an example file , i was to remove rows like 5,6,7,8 from the file.i have a basic knowledge about VBA and failed to find a solution using it.
i am trying for a solution in excel maybe with formulas or VBA.
Regards,
Leeroy.
October 5, 2010
Offline
Hi Leeroy,
there is no file attached.
Regards
Phil
Active Member
December 4, 2019
Offline
sorry,
please find the attachment below
VIP
Trusted Members
June 25, 2016
Offline
Hi Leeroy
I would copy column B to Googlesheets and then use DETECTLANGUAGE() to get the language code.
Then copy the results back to Excel and filter for results not equal to en (English) to delete the rows.
Sunny
1 Guest(s)
