Split 5 digit number into 5 cells
WOW brilliant - that was much neater than a formula I saw a while ago.
Many thanks
Kenny
"PCLIVE" wrote in message
...
You could put this formula in A2 and copy down.
=MID($A$1,ROW()-1,1)
HTH,
Paul
--
"Forum Freak" wrote in message
...
Hi everyone
I am sure I have seen this before but it is not showing up on Google.
A1 has a 5 digit number eg 12345
I want a formula or VBA code to produce
A2=1
A3=2
A4=3
A5=4
A6=5
anyone point me in the right direction?
Kenny
Win XP
Office 2003
|