Looking to break a large number down

[Guest]

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

 

[Guest]

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