| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I create two columns from one column (space separated info
I have a column of info separated by a space. Can I select this column and
convert to two columns? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create two columns from one column (space separated info
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. "vikki_socal" wrote in message ... I have a column of info separated by a space. Can I select this column and convert to two columns? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I create two columns from one column (space separated info
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple columns of data into one long column | Excel Discussion (Misc queries) | |||
| Same info from one column to different columns in multiple worksheets | Excel Discussion (Misc queries) | |||
| How do I create multiple columns within one column? | Excel Discussion (Misc queries) | |||
| Stack multiple columns into one column... is there an easy way? | Excel Discussion (Misc queries) | |||
| Arithmetical Mode of Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Linear Mode
