On Mon, 5 Jun 2006 14:07:56 -0500, Rikuk
wrote:


Hi I have cells that contain numbers of various lenghts how do I split
the last 2 digits only in to seperate cells

I've tried =RIGHT command but this does not work as I require

I.e

156974 split into two seperate cels would be (4) & (7)
589 split into two seperate cels would be (8) & (9)



Mathematically, one could use:


=MOD(INT(A1/10),10)
=MOD(A1,10)


--ron