[Microsmith]

I have a solution though it is somewhat convoluted.

1. Copy entire text range to excel (paste values) starting at cell A1
2. In a column next to the pasted text, type the following formula, then
copy it down however many rows needed:

=TRIM(SUBSTITUTE(A1,CHAR(160),CHAR(32)))

The formula will convert the text to something like:
1 a c d
2 c b c


3. Copy the range containing the formulas back to Word 2007.
4. Use Word 2007's "Convert Text To Table" and in the
"separate text at" section choose "Other" and type in a space using
your spacebar in the box to the right.
5. Click OK.

Works great for me.






"paper" wrote:

I am tring to covert text to table while the text is sparated by mutiple
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