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...
Alternatively, if this is a one-time exercise, just enter this formula (assuming your text like 1#Apple) is in A1:
=RIGHT(A1,LEN(A1)-2).... and copy it all the way down. If needed, you can copy-paste the whole column as values on top of itself and delete column A.