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

V

vikki_socal

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

Guest

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.
 
R

Ron Coderre

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
 
Top