remove emoji's & string values

[Imran Qamar]

Greetings of the day! can anyone assist me to remove emoji's, string , i have data more than 600k like it and i want to remove emoji's strings in the data, there are arabic and english text also
and i want to keep arabic, english and numeric values alive in the sheet

 

[pecoflyer]

Cross post https://www.mrexcel.com/board/threads/remove-emojis-string-values.1198679/

 

[vletm]

Imran Qamar
Please reread second time Forum Rules

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...

chandoo.org

There are clear sentences about Cross-Posting.
... and same kind of rules are everywhere.

 

[Imran Qamar]

ok vletm am sorry one more time, but as a new member i had no idea about all these above mistakes i 've made, thank you so much for pointing out second time, i have read and understood almost all rules now but still waiting anyone of you guys to solve my problem, please tell me should i delete my query and post it again or wait for respond?

 

[vletm]

Imran Qamar
As You wrote Yourself - Your're a new member
... then of course, a new member would study how these Forums work before start to do posting
Did You notice link - New Users - Please Start Here ?

About Your please tell me ...
Please reread How to get the Best Results at Chandoo.org from Forum Rules.
After that You would find out - what to do next?

Have You tried to 'Google'? eg remove emoji strings

https://stackoverflow.com/questions/24672834/how-do-i-remove-emoji-from-string

 

[Imran Qamar]

yes vletm am a new member, and i have already accepted i made mistakes twice, i was in rush and didn't read the rules and that's why i asked to excuse me, thanks for the link, let me check and revert if it works, hope i haven't made any mistakes in this post

 

[Imran Qamar]

vletm thank you for the link though it's not working for me, anyways thanks for the guideline

 

[vletm]

Imran Qamar
... hmm?
Are You still rushing?
Did You try to use its information?
What is missing?
It's normal that others codes should need minor modifications.
I tested ...