Find a word based on # and copy word to another cell
Closed
AmandatB89
-
Oct 30, 2015 at 07:01 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Nov 2, 2015 at 10:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 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!
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!
Related:
- Find a word based on # and copy word to another cell
- Word apk for pc - Download - Word processors
- Word watermark on all pages - Guide
- Number to word in ms word - Guide
- How to search for a word on a page - Guide
- Word full screen - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Nov 2, 2015 at 10:47 AM
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
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