Data Between 2 Double Spaces

[bobgrand]

Hello all,

Our system generates a report that puts double spaces between each column of data. Material#, Description1, Description2, Description3. All of this data is in column A. I am struggling trying to get these into their own column. So I would need Material# in Column B, Desc1 in Column C, Desc2 in Column D and Desc3 in Column E.

Any help is always appreciated

 

[Joe4]

Are you saying that there is two spaces between each field?
If so, then perhaps you can do a Find/Replace, replacing TWO spaces with something like a ~
Then, you select that column, go to the Data menu and select "Text to Columns", choose the "Delimited" option, and enter a ~ in the "Other" box, and click Finish.
This should separate them all into their own columns.

 

[Joe4]

Use Data, then Text to Columns.
Select Delimited
Click Next
Check Space as the delimiter. Make sure the box that says Treat Consecutive Delimiters as one is checked.
Click Finish

Good point - as long as there aren't any single spaces that aren't the part of any delimiter, you could cut out the extra step I proposed about changing the delimiter.
If some headers might have multiple words with single spaces between them, then you would need to do something like what I proposed.
But if your example of column headers is accurate and complete, you should be fine using Scott's shorter version.

 

[Scott Huish]

Good point - as long as there aren't any single spaces that aren't the part of any delimiter, you could cut out the extra step I proposed about changing the delimiter.
If some headers might have multiple words with single spaces between them, then you would need to do something like what I proposed.
But if your example of column headers is accurate and complete, you should be fine using Scott's shorter version.

I deleted it because I realized that

 

[Joe4]

I deleted it because I realized that

They don't seem to be showing any not delimiter spaces in their example, so I think your solution should work, if that is in-fact accurate.