Hello DLW,

That works for my numbers, UNLESS the first number is a 0 (ie. 098 returns
as 9 | 8 | 8.

It's possible that I have to make it a text.. but when I tried it still
drops off the beginning 0. :(

Does anyone have any other suggestions or incorporate the =LEFT / MID / RIGHT

Thank You.
David

"dlw" wrote:

=left(k1,1)
=mid(k1,2,1)
=right(k1,1)



"David" wrote:

Sorry, I would search the topics but I am unsure even what to look for.

I have a column of number that are three digits in size. They could range
from 001 through 999. I would like to split it up so each digit is in it's
own column. So if ColumnK had the number 459 in it then I would like ColumnM
to show the number 4, ColumnN to show the number 5 and ColumnO to show the
number 9. Same with if the number is 99 (ColumnK would show 099, and I would
want the number 0 to show in ColumnM).

Thank You Everyone who knows how to do this. :)
David