Forum Discussion
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 ...
Maybe the delimiter is just a tab character.
Did you try opening the file from excel?
Or just open a blank workbook and try to import the file using power query, which usually autodetects the delimiter. To do so, go to Data tab, then in Get & Transform Data group of icons use From Text/CSV.