Hello. I've scraped tweets that contain emojis in an Excel sheet, however, the emojis/emoticons are displayed as hex codes. Could you please help me with getting them displayed as emojis?
Thanks.
Thanks.
g3l.xlsx | ||||
---|---|---|---|---|
A | B | |||
1 | tweets | cleaned_tweets_with_emojis | ||
2 | Lets go @KingJames !!!! We got this @Lakers !!!!!!!! 11:11 #LakeShow | |||
3 | Cmon @Lakers we got this!! <U+0001F49C><U+0001F49B> #LakeShow #LAKERSNATION | |||
4 | Me giving my energy to the @Lakers so we can win in the 4th quarter #LakeShow #LakersNation https://t.co/GbMHFaFwEE | |||
5 | Okay okay...I guess @Lakers, we can’t make it too easy...Lakers in 5, we can give them this game <U+0001F605> #LakeShow | |||
6 | Helluva game from @JimmyButler. Let’s see if we get a repeat in game 3. The @Lakers can’t play this poorly again, right?! #LakeShow | |||
7 | Not surprised of this result. We sorta knew @lakers werent going to come in as expected. It always takes a lost to wake up. On to the next. #lakersin5 #LakeShow #LakersNation | |||
8 | Great job @Lakers <U+0001F608><U+0001F4AA><U+0001F3FE><U+0001F4AA><U+0001F3FE> we still on top #NBAnaESPN #LakeShow | |||
Sheet2 |