Forum Discussion
remove characters from a column
I have a column with about 800 rows which each contain a symbol, number, and text. Here's an example "#1Apple". How do I keep only the alpha characters and delete the rest. So, the above exampl...
IMHO, if the number is always only one digit, Text to Columns is the fastest and easiest way.
If few digits, not sure what I'd prefer - Power Query with split as
or CSE formula like
=RIGHT(A1,LEN(A1)-MAX(IFERROR(FIND({1,2,3,4,5,6,7,8,9,0},A1,ROW(INDIRECT("1:"&LEN(A1)))),0)))Each has pros and cons.