Convert text to table with SPACES separator

[paper]

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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

 

[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]

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

 

[Suzanne S. Barnhill]

You can type a space into the Other box.

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

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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

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

 

[Graham Mayor]

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

You can type a space into the Other box.

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

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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

 

[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

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


<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

You can type a space into the Other box.

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

:

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

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


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