Find/Extract Emojis from Excel

Viewed 374

With Twitter Archiver (TAGS), I've collected tweets like that:

RT @LeyLaLaa: FINLAND | 8 ways to summer like the Finns in the Turku Archipelago ☀️ Sauna, lake, repeat ... @OurFinland #ttot

I've exported the spreadsheet in Excel. Now I want to find which emojis are the most used. For this tweet, I should have ☀️ and .
I also try to extract and count #hashtags, links, pics/videos, etc..

Any idea of the the formula?

0 Answers
Related