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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of info separated by a space. Can I select this column and
convert to two columns?
 
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.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Split column contents (de-concantenate) 7
text to column 1
How to filter Unique values from Duplicates 6
Separate Text from a cell by space into other cells 5
combining multiple columns using ", " seperations.. 4
CSV Column Conversion 2
Subtracting based on 2 conditions 3
Reformatting data 3

Back
Top