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.