Dave Barton wrote:
-------- Original Message --------
From: Wade Smart <[email protected]>
To: [email protected]
Date: Sat, 31 Jul 2010 10:46:42 -0500
I need to get the product code from a numeric string.
I tried RIGHT(C2,4) but apparently this only works with letters and not
numbers.
Wade
Does =RIGHT(TEXT(C2,"#"),4) do what you want?
Dave
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
no.
=RIGHT(TEXT(C2,"#"),4)
C2 = .. (last six digits) 0/1981
the above function produces 9736
Wade
--
Registered Linux User: #480675
Registered Linux Machine: #408606
Linux since June 2005
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
