Forum Discussion
Solved
How to find/replace all text before and including the asterisk?
All the new payment options list themselves before the vendor purchase name along with an asterisk. How do I remove all text BEFORE AND INCLUDING the asterisk?
CxxSH APP*GEORGE (had to add the xx since it wasn't accepted in this post)
FSP*VILLAGE LINKS
GLF*MILLCREEKGOLFCLUB
MP-*USGA Golf Handicap
PAYPAL *STEAM GAMES
SQ *X-GOLF
=RIGHT(A1,LEN(A1)-FIND("*",A1))
This formula removes all text before and including the asterik in my sheet.
3 Replies
=RIGHT(A1,LEN(A1)-FIND("*",A1))
This formula removes all text before and including the asterik in my sheet.
- Do you know I Googled forever to find this answer and no one answered it and/or showed how to do this with an asterisk as the character!? All the examples were using another character and so they would use the wildcard options, which didn't work with the character I'm trying to find/replace is an asterisk! Thank you!
- alternatively if you have Excel 365:
=TEXTAFTER(A1,"*")
or in case you have an entry without an "*" then use:
=TEXTAFTER(A1,"*",,,,A1)
and if you might have more than 1 "*" and only want text after the last one then maybe:
=TAKE(TEXTSPLIT(A1,,"*"),-1)
