Forum Discussion

VeeDee1660's avatar
VeeDee1660
Copper Contributor
Jul 17, 2023

convert txt to excel with spacing more than 1 space

Hi all. I'm trying to convert a text file to an Excel sheet but just have 1 smallish issue.

 

The Txt file is formatted like this

 

"399        Testing: Testing 14.        confirmed testing: testing 14" and it repeats this weird format

 

I want those big spacers between like 399 and Testing: Testing 14 to be the column separator and so on and so forth. How could I do this?

 

 

excel
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor
    Jul 17, 2023

    VeeDee1660 If you have Excel365 you could use the TEXTSPLIT function and use 8 consecutive spaces as the column separator. That would look like this:

    If this is not what you had in mind please clarify and provide some more examples. Perhaps you can share a link to a file on OneDrive or similar.

    There are other tools in Excel that can split texts into columns. Which one to use depends on the source, size and quality of the data files, how often you need to do this and your platform (Windows/Mac/Web) and Excel version.

Resources