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 January 16, 2023 - Nov 2, 2015 at 10:47 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Nov 2, 2015 at 10:47 AM
Related:
- Find a word based on # and copy word to another cell
- Word free for u - Guide
- Vim find word - Guide
- Number to text in word - Guide
- Word 2007 pdf add on - Download - Other
- Word viewer - Download - Office suites
1 response
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
549
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