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

Closed
AmandatB89 - Oct 30, 2015 at 07:01 AM
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 - Nov 2, 2015 at 10:47 AM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Nov 2, 2015 at 10:47 AM
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