NEED URGENT HELP separating this row into 9 columns

[Sivory18]

Hello as you can see all the data is in 1 row, but need to separate it into 9 columns. I have provided 2 screenshots of what it looks like and what i want it to look like. 

[KGT]

Is there any chance that you can put up a sample with a couple of rows data? 

My first thing that I would check is whether the 2nd row is dots signifying how many characters are in each column. If so, then you can basically specify how long each field is and with a couple formulas parse it all out at once. In the screenshot, it looks like there is 9 sets of dots in-between dashes, and so this would most certainly be the first thing to check.

• If it is, then count the dots between dashes and then a REGEX parse formula such as (.{18}(.{12}).... etc will separate into columns of that size.
• The dynamic way to do this, is to transpose that row, tag, then count. Then insert those results into a macro that creates the substring formulas.

If that is not the case, then a similar method may work as they do appear to be column spaced. If they are tab separated, then \t will work in Text to Columns for instance.

[Yash9889]

I hope this helps! If you need any further assistance, feel free to reach out. For more clarity, please provide a sample input.

[PangHC]

normally this kind of file will fixed length for each columns, even the number columns. the extra will become space.

simple way is to count each length of column and do as what @KGT said to parse via regex

or else you can try to use this macro. (just macro version that simplify the regex into split by char number.)

[MikeBird]

@Sivory18 
Similar to this approach, I have used the RegEx tool to Tokenize to columns using expression \S+\s{2}|\S+$

This looks for any number of non-white space (\S+) characters followed by 2 spaces (\s{2}) and then the rest of the characters at the end of the string (\S+$). 

Your columns 3&4 and 7&8 are combined but this is an easy split using a formula tool.