-------- 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]

Reply via email to