| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL: Separating data from 1 cell into multiple cells
I have thousands of cells in a report with information that I need to
separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: Separating data from 1 cell into multiple cells
Hi,
Highlight the column, Text to columns, Delimited, next, check only the Other box and copy your | in the box beside it, next, finish "HeatherJ" wrote: I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: Separating data from 1 cell into multiple cells
Thanks, perfect!
"Eduardo" wrote: Hi, Highlight the column, Text to columns, Delimited, next, check only the Other box and copy your | in the box beside it, next, finish "HeatherJ" wrote: I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: Separating data from 1 cell into multiple cells
Just in case you are having trouble finding the | to insert in the delimiter
box, it's the upper case of the key directly below the Backspace key on a standard US keyboard. It shows as a vertical broken line on my keyboard. (Lower case on that same key is the back-slash) HTH Regards, Howard "HeatherJ" wrote in message ... I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: Separating data from 1 cell into multiple cells
Called a "pipe"
Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 07:44:07 -0800, "L. Howard Kittle" wrote: Just in case you are having trouble finding the | to insert in the delimiter box, it's the upper case of the key directly below the Backspace key on a standard US keyboard. It shows as a vertical broken line on my keyboard. (Lower case on that same key is the back-slash) HTH Regards, Howard "HeatherJ" wrote in message ... I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL: Separating data from 1 cell into multiple cells
I've never heard of that... thanks, learn something every day.
Howard "Gord Dibben" <gorddibbATshawDOTca wrote in message ... Called a "pipe" Gord Dibben MS Excel MVP On Thu, 19 Nov 2009 07:44:07 -0800, "L. Howard Kittle" wrote: Just in case you are having trouble finding the | to insert in the delimiter box, it's the upper case of the key directly below the Backspace key on a standard US keyboard. It shows as a vertical broken line on my keyboard. (Lower case on that same key is the back-slash) HTH Regards, Howard "HeatherJ" wrote in message ... I have thousands of cells in a report with information that I need to separate into different cells. Ex. one cell: Arch | South | All Points | Extreme I need an automated way to get each of the 4 names separated by "|" into its own cell. Any suggestions? Thanks, Heather ) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separating data from cells | Excel Worksheet Functions | |||
| Separating Data in one cell to multiple cells | Excel Discussion (Misc queries) | |||
| Separating Two Data Sets from one Excel Cell into Two Cells | Excel Discussion (Misc queries) | |||
| separating data into multiple columns | New Users to Excel | |||
| Separating Data Into Multiple Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
