View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
 
Posts: 5,651
Default extract and assign numerics to characters

On Sun, 16 Nov 2008 22:40:04 -0500, "Rick Rothstein"
wrote:

I think you will need to expand this formula to handle product codes that
begin with one or more A's (they turn into leading zeroes which are dropped
because a number is being returned). Consider this instead...


Nice pickup and solution.
--ron