Hello c,
welcome to the forum.
It may be possible to parse the data into columns using "text to columns". Can you upload an Excel file with a few dozen rows of sample data?#
Click "Go Advanced" below and then the paper clip icon to attach a file. Make it small. A few dozen rows will be enough.
Bookmarks