How do I create two columns from one column (space separated info

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

vikki_socal - 25 May 2006 16:04 GMT

I have a column of info separated by a space. Can I select this column and
convert to two columns?

Reply to this Message

Andy - 25 May 2006 16:13 GMT

Hi

Make a backup first. Select your column and go to Data/Text to Columns. Use
Delimited and select <space> as your delimiter.

Hope this helps.
Andy.

>I have a column of info separated by a space. Can I select this column and
> convert to two columns?

Reply to this Message

Ron Coderre - 25 May 2006 16:14 GMT

Try this:

First, make sure there is an empty column to the right of the cells to be
spiit.

Then
Select the cells to be impacted

From the Excel main menu:
<data><text-to-columns>
Check: Delimited.....[Next]
Delimiter: Check Space.....[Next]
(Check any other options that apply)
Click the [Finish] button

Does that help?
***********
Regards,
Ron

XL2002, WinXP

> I have a column of info separated by a space. Can I select this column and
> convert to two columns?

Reply to this Message