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...
=RIGHT(A1,LEN(A1)-FIND("*",A1))
This formula removes all text before and including the asterik in my sheet.
=RIGHT(A1,LEN(A1)-FIND("*",A1))
This formula removes all text before and including the asterik in my sheet.
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)
=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)