Give these formulas a try:

=MID(TEXT($A1,"000"),1,1)
=MID(TEXT($A1,"000"),2,1)
=MID(TEXT($A1,"000"),3,1)

There are some other formulas which may be shorter, but without knowing
exactly how your data is stored (ie. number or text), they may not work. The
above formulas should work regardless of how your data is stored.

HTH,
Elkar

"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