| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Separating Data in one cell to multiple cells
We receive data from a company where the Item Name, UPC, and pack size are
all listed in the same cell like so: Test Item, 12345-61489, 12pk Is there a way to convert this cell so that the Item Name, UPC, and pack size would be listed in separate cells. The UPC size would be constant, but the lenghth of the Item Name and Pack Size would vary. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Separating Data in one cell to multiple cells
ONe way:
Data/Text to Columns/Delimited, Comma. In article , Supe wrote: We receive data from a company where the Item Name, UPC, and pack size are all listed in the same cell like so: Test Item, 12345-61489, 12pk Is there a way to convert this cell so that the Item Name, UPC, and pack size would be listed in separate cells. The UPC size would be constant, but the lenghth of the Item Name and Pack Size would vary. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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) | |||
| Separating information in one cell into several cells | Excel Discussion (Misc queries) | |||
| Separating data in a cell | Excel Discussion (Misc queries) | |||
Linear Mode
