Find a word based on # and copy word to another cell

Closed
Report
-
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
-
Hi all,

I have a lot of social media messages in row 1 below eachother, and my goal is to find all the hashtages from the messages. For example:

In cell A1 I have a social media message, for example;
I really had a good holiday #sun #italy #enjoylife.

In cell B1 I want to have all the words which are preceded by the #-sign. Is there a way I can tell excel to find all the #, and copy both the # and the word attached to it to cell B1? And in case I have multiple # in one social media message, would excel put them all together in a cell or in seperate cells behind eachother?

Thank you very much!

1 reply

Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
Hi AmandatB89,

The formula below will look for the first hashtag and then display's everything behind it including the first hashtag.

Give it a try:
=RIGHT(A1,LEN(A1)+1-FIND("#",A1))

Best regards,
Trowa
0