Separating Data in one cell to multiple cells

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Populate workbook A from Data in workbook B based off criteria in Workbook C 0
Separating carriage return data into separate cells 2
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Pulling Multiple Text Strings in a One Cell 4
EXCEL: Separating data from 1 cell into multiple cells 5
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0
Separating Names in a Cell 3
Excel, assign cells in multiple worksheets from one sheet 1

Top