View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Supe Supe is offline
external usenet poster
 
Posts: 59
Default 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.