Converting Text to Column issue

[khawarameer]

Hello All,

I need to convert a text string to columns. The fields of the string are bifurcated with 3 to 4 spaces each. However the string contains "Name" and "Address" fields which naturally have spaces. When i use to option text to column using spaces it takes every word of name and address fields and put them in separate columns. Is there a way to put a special character where ever more than one space occurs in the string. It will solve my problem.

Regards


Khawar

 

[Michael M]

Have you considered doing a Find / replace ....find the 3 or 4 spaces and replace with say a comma.
So, then the text to columns will only split at the spaces ?

 

[khawarameer]

Have you considered doing a Find / replace ....find the 3 or 4 spaces and replace with say a comma.
So, then the text to columns will only split at the spaces ?

I have tried Find and Replace however doing so fills the special character on every space.

 

[MARK858]

You must have only typed one space in the find and replace, if it is 3 spaces type 3 spaces in the Find/Replace.
If you type 3 spaces then it won't replace a single space.

 

[Michael M]

Thanks Mark, my comment obviously wasn't clear enough...

 

[khawarameer]

Thanks Mark, my comment obviously wasn't clear enough...

It worked. Thank you both Michael and Mark.

 

[Michael M]

glad we could help..