Excel 2007 : Split letters in cell into multiple cells:

**Miles Tails** · 07-28-2009, 03:46 PM

I was just curious.

If I have a line of text and numbers e.g: "ABC123" in one cell, say cell B1, that was created by:

Please Login or Register  to view this content.

Which respectfully are:
"A", "B", "C", "1", "2", "3", "", ""

Could I take that line of text and numbers from B1 and make it into a row of cells, each with one letter?

Making a delimiter (for a table) may be tricky, since I cannot change row A's letters/numbers.

Thank you in advanced.

**JBeaucaire** · 07-28-2009, 03:51 PM

If the value to split is in B1, then in any cell to the right enter this formula, then copy the cell to the right:

=MID($B1,COLUMNS($A$1:A1),1)

**Miles Tails** · 07-28-2009, 06:32 PM

I ended up trying:

Please Login or Register  to view this content.

Which I wouldn't have been able to do without your help. I got my desired results.

Thank you so much!
(Solved)

**JBeaucaire** · 07-28-2009, 06:54 PM

If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].

(Also, use the blue "scales" icon in our posts to leave Reputation Feedback, it is appreciated)