[Suzanne S. Barnhill]

I don't have an option for spaces, either, which makes me wonder if the OP
might be using WordPerfect or something else. Also, IIRC, you can't enter
more than a single character in the Other box, so you couldn't enter two
spaces. I jumped into the middle of the thread and didn't see that that was
what was wanted.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

"Graham Mayor" wrote in message
...
You can, but it splits text at *every* space.
I have the same Word version as the OP and mine does not have an option
for Spaces?
The macro I posted earlier will do it.

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



Suzanne S. Barnhill wrote:
You can type a space into the Other box.


"paper" wrote in message
news
Hi Graham,

I just checked the version used in my office. It is WORD professional
edition 2003 (11.8227.8202) SP3. And there is an option "Space"
under the "Separate text at" in the "Table--Covert---Text to table".
It is suprising because there are only 4 options under the "Separate
text at" in WORD 2007 and other version of WORD 2003 I used before.
However, the one in my office
has 5 options. That is, one additional option "Space" there.

I don't know if there is any way that I can put "Space" as an option
under the "Separate text at".

Thanks

"Graham Mayor" wrote:

I don't see that option in either Word 2003 or 2007, however the
following
macro should do the trick

With Selection
With .Find
.ClearFormatting
.Replacement.ClearFormatting
.Text = "[ ]{1,}"
.Replacement.Text = ", "
.Forward = True
.Wrap = wdFindContinue
.MatchWildcards = True
.Execute Replace:=wdReplaceAll
End With
.WholeStory
.ConvertToTable Separator:=wdSeparateByCommas
End With

If you want to break the text where there are two spaces or more
change the
{1,} to {2,}
http://www.gmayor.com/installing_macro.htm

--

Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org



paper wrote:
I am trying to covert text to table while the text is separated by
multiple spaces, like following:

1 a c d
2 c b c

Obvious, the nuber of spaces between different columns varies. I
can covert the above text to table easily in my office, using the
table-convert text to table in Word 2003. In that version, I can
see the "Separate text at" "Spaces". And the WORD will recognize
multiple spaces as only one, and separate the text correctly.
However, in my laptop, which uses Word 2007, there is no obvious
"Spaces" as an option under "Separate text at", so I have to input
the space in the "Option" area. Unfortunately, after doing that,
the multiple spaces in the text will also create several columns,
which I don't want to see.

Any solutions?

Thanks