Are you perhaps talking about:
In D1, enter,
=LEFT(C1,5)
OR
=--LEFT(C1,5)
to retain numerical format.
--
HTH,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"klafert" wrote in message
...
I used it before and cant remeber the function command that will allow me
to
copy just the 1st 5 numbers in a cell to another cell. Thes cells are like
C
& D.
Thanks for your help. Command just slipping my mind.
|