Hello everyone
i am cleaning a massive fine that contacts emails.
the problem is that there are also Emoji and when i run the below formula, the emojis are kept
=TRIM(RIGHT(SUBSTITUTE(LEFT(A1,FIND("@",A1)-1)," ",REPT(" ",99)),99))&MID(A1,FIND("@",A1),FIND(" ",A1&" ",FIND("@",A1))-FIND("@",A1))
is there a way to remove all of the emojis in one go?
The file is 175000 rows so any help is appreciated
cntrl + H
find emojis
replace by leave blanc
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
is it the same command on a MAC??
No, the solution provided by @oeldere is find and replace command which is available in Windows also.
You need to type in every single emoji and replace it by blank.
Also, Can you attach a sample file with desired results manually shown?
You can attach a sample file by clicking on "Go Advanced" button at the bottom of the post and then selecting the "Paper Clip" icon from the tools above.
Happy to Help
How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html
"I don't get things easily, so please be precise and elaborate"
If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.
Sourabh
here is a sample data
We need to develop a formula. For that we need some criteria to clean the strings. For example - all emoji begin with @, etc. So, please specify these criteria, on the basis of which we can make a formula.
Also tell what should be the desired results.
Try to cover all the possible variations of strings so that a dynamic formula to suit all cases can be built.
See the forumrules about crossposting.
http://www.mrexcel.com/forum/excel-q...ji-string.html
I am not an expert, my gut feeling is replace what not A-Z or 0-9 or @ with ""
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks