Forum Discussion

gpatrick79's avatar
gpatrick79
Occasional Reader
Jun 25, 2026

separate columns in excel (imported from .txt file)

Hi all.

 

I have a a table to bring in from a .txt file lots of lines with an excerpt below.

I have tried to import data and copy paste etc and then tried to separate columns using delimiters and also number of characters but there is no consistency in the numbers in the columns, it keeps separating different rows differently (ie if i use space the title of the object on the 2nd row may have two or three words so using space as a delimiter is out, same for the number of characters and position).    Any suggestions - is too much data to try and clean up by doing one of the above then trying to tidy it!

 

 

No RepliesBe the first to reply