Text To Columns
 

I have a column of part no. and descriptions that are separated by a space. I
know how to separate them with the help of DATA/TEXT To COLUMN However when
I use the fixed option and move my vertical arrow to separate the part no.
and description I end up either not grabbing the whole part no. or the
description. Is there way I can add spaces /indent so that I can use that
option?

Text To Columns
 

Can you use the delimited option, and select space as the delimter?

Beege

"JR" wrote in message
...
I have a column of part no. and descriptions that are separated by a space.
I
know how to separate them with the help of DATA/TEXT To COLUMN However
when
I use the fixed option and move my vertical arrow to separate the part no.
and description I end up either not grabbing the whole part no. or the
description. Is there way I can add spaces /indent so that I can use that
option?

Text To Columns
 

I think I will step away from the PC right now. That worked.

Thanks,
JR

"Beege" wrote:

Can you use the delimited option, and select space as the delimter?

Beege

"JR" wrote in message
...
I have a column of part no. and descriptions that are separated by a space.
I
know how to separate them with the help of DATA/TEXT To COLUMN However
when
I use the fixed option and move my vertical arrow to separate the part no.
and description I end up either not grabbing the whole part no. or the
description. Is there way I can add spaces /indent so that I can use that
option?