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
Related:
- Find a word based on # and copy word to another cell
- Word apk for pc - Download - Word processors
- Number to text in word - Guide
- Word watermark on all pages - Guide
- Word to xps download - Download - Other
- How to search for a word on a page - 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