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