avadhutd2
09-07-2009, 06:37 AM
Hi,
I need to split a 6 digit number into two - first digits & remaining 5 digits.
As a example - Consider Cell A1 had value 123456 & we will have to split it into two parts as "1" & "23456".
Can I store these separated values some where and use it?
I need these to be split as I need to compare these values with some other.
Thanks in advance...
I need to split a 6 digit number into two - first digits & remaining 5 digits.
As a example - Consider Cell A1 had value 123456 & we will have to split it into two parts as "1" & "23456".
Can I store these separated values some where and use it?
I need these to be split as I need to compare these values with some other.
Thanks in advance...