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


"vikki_socal" wrote:

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