MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Converting multi-digets in one cell into each diget in it's own cell

Posted by Coney on December 24, 2001 5:04 PM

I have a spreadsheet with a list of 10 diget upc codes all of the digets are in one cell. What I need is each diget in it's own cell.

Posted by FrankB. on December 24, 2001 6:17 PM

Try this:
Your 10-digit number in cell A1
In cell A2, type in the following formula, then drag-and-fill through cell J1 (column 11):
" =(MID($A$1,COLUMN(A1),1))" (without the quotes)

HTH, FrankB

Posted by Chris D on December 24, 2001 9:15 PM

you could also highlight the column, selecting :

Text to columns
fixed width

and click to insert column seperators as needed after each character

Frank's method is probably quicker and I've often found copy/paste problems after using text-to-columns (ie reboot)

Another option though !
Chris D