Text to Columns on Two, or more, blank spaces?

[blbat]

In Cell A1 I have a Huge Text String that originated in a .pdf file.

There are no useful delimiters, such as commas or semi-colons.

any text that has two or more spaces between is a field in the original .pdf

is there a way to split this out is by using two or more blank spaces as the delimiter?

 

[sandy666]

 

[blbat]

Thanks, that splits it out on a single space. I need it to split it out on two, or more, spaces.

 

[sandy666]

post #2 contain 5 spaces
here is the same

maybe describe with details what you want to achieve or post link to the shared file (excel) with example of data

 

[blbat]

Thanks for your patience Sandy...

May be there's a lot more garbage embedded in this text string than I thought.

The data preview box is blacked out when I duplicate your steps above.

I'm sorry I can't post the file.

I'll keep trying.

 

[blbat]

Thanks for your patience Sandy...

May be there's a lot more garbage embedded in this text string than I thought.

The data preview box is blacked out when I duplicate your steps above.

I'm sorry I can't post the file.

I'll keep trying.

 

[sandy666]

try select ONE column then use Text2Columns without/with that option

check text against hard space, another name: non-breaking space. CHAR(160)

 

[blbat]

it's actually one Cell.

I made some headway using a Find/Replace using Ten blank spaces replaced with two blank spaces. it's a painful way to have to do it.

 

[sandy666]

maybe
Find: two spaces
Replace: one space

then Replace All few times as you see: We couldn't find anything to replace.. etc..

btw. column can contain single cell also

 

[Rick Rothstein]

maybe
Find: two spaces
Replace: one space

The OP said the cell contained a "Huge Text String", so I think we can assume there are lots of single space characters in it. The OP does not want to split on these single space characters, rather, he wants to split where there are two or more adjacent space characters next to each other.