Forum Discussion
Separating mixed data into meaningful pieces
Hello all, My question is about converting the text into columns with the Excel. All i want is to convert the mixed text data in a column into meaningful data pieces with an elegant/smart move. I am...
Floyd35 Assuming your real data contain more than just a few rows, I suggest you look into Power Query. Connect to the table and split the column where where a digit is followed by a character.
Attached and example.