Forum Discussion
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: test...
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.