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...
Load all the data into Power Query and use Split column
1. Click anywhere in the data and execute CTRL + T to format as Table
2. In the Data tab, click on From Table/Range
3. In the Power Query Editor, click on Split Column by Positions
4 In the Split by Positions dialogue box, type in 2 in the box
5. Click OK
All the unwanted characters are removed
Then, you can Close and Load to load the result back to Excel as seen in the caption below
