| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
separate contents of one cell into multiple cells
Hi !
Is there a way to separate a content in one cell into mutiple cels?? I have this: Portugal,KM25,2,euros,2002 what I´m looking for is separate all this between comma like Portugal in one cell km25 in other cell 2 in other and so. Thanks Horacio |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate contents of one cell into multiple cells
Try Text to column under Data (2003) using coma as the delimiter.
HTH Regards, Howard "Horacio" wrote in message ... Hi ! Is there a way to separate a content in one cell into mutiple cels?? I have this: Portugal,KM25,2,euros,2002 what I´m looking for is separate all this between comma like Portugal in one cell km25 in other cell 2 in other and so. Thanks Horacio |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate contents of one cell into multiple cells
If always comma-delimited use DataText to Columns
Gord Dibben MS Excel MVP On Sat, 23 Jan 2010 14:24:46 -0800 (PST), Horacio wrote: Hi ! Is there a way to separate a content in one cell into mutiple cels?? I have this: Portugal,KM25,2,euros,2002 what I´m looking for is separate all this between comma like Portugal in one cell km25 in other cell 2 in other and so. Thanks Horacio |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate contents of one cell into multiple cells
On 23 Jan, 22:57, Gord Dibben <gorddibbATshawDOTca wrote:
If always comma-delimited use DataText to Columns Gord Dibben *MS Excel MVP On Sat, 23 Jan 2010 14:24:46 -0800 (PST), Horacio wrote: Hi ! Is there a way to separate a content in one cell into mutiple cels?? I have this: Portugal,KM25,2,euros,2002 what I m looking for is separate all this between comma like Portugal in one cell km25 in other cell 2 in other and so. Thanks Horacio Thank you for the help I did not know this tool. Horacio |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
separate contents of one cell into multiple cells
If this is a single column, you can select the range (that single column) and
use: Data|text to columns Delimited (by comma) and specify how each field should be treated. I'd insert some columns to the right (first) so that I wouldn't overwrite them with this parsed data. Horacio wrote: Hi ! Is there a way to separate a content in one cell into mutiple cels?? I have this: Portugal,KM25,2,euros,2002 what I´m looking for is separate all this between comma like Portugal in one cell km25 in other cell 2 in other and so. Thanks Horacio -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to separate the contents of one cell into two cells in Excel 2 | Excel Discussion (Misc queries) | |||
| Partitioning Excel cell contents into separate cells | Excel Discussion (Misc queries) | |||
| Excel 2000 - Split Contents of Cell Across Multiple Cells | Excel Discussion (Misc queries) | |||
| How do I combine the contents of multiple cells in one cell? | Excel Worksheet Functions | |||
| how do i automatically archive old cell contents to a separate . | Excel Discussion (Misc queries) | |||
![Horacio[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
