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.

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.