Initially in AJ25 I had 123456789,
Now I have 1234567.89
I want to extract the numbers as follows:
Cell P25 should end up with the 1.
Cell Q25 should end up with the 2,
Cell R25 should end up with the 3,
etc. all the way thru, including cell X.
I don't want the "decimal point" to extract.
I've tried the following:
=MID($AJ$25,Column()-1,1)
on the number 123456789, and copied this from P thru X,
but all I got were blank cells from P thru X.
Any suggestions?
Thanks,
Zac
Now I have 1234567.89
I want to extract the numbers as follows:
Cell P25 should end up with the 1.
Cell Q25 should end up with the 2,
Cell R25 should end up with the 3,
etc. all the way thru, including cell X.
I don't want the "decimal point" to extract.
I've tried the following:
=MID($AJ$25,Column()-1,1)
on the number 123456789, and copied this from P thru X,
but all I got were blank cells from P thru X.
Any suggestions?
Thanks,
Zac