View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.misc
[email protected] domenic22@sympatico.ca is offline
external usenet poster
 
Posts: 14
Default Remove Numbers from Alphanumeric String

On Oct 26, 2:03 pm, Dave wrote:
Hi,

I have a value in Cell A of ABC123.

I want Cell B1 to contain the 123 from this cell.

Can anyone tell me the formula to enter in B1. I'm sure I've seen it
somewhere before but can't put my finger on it.

Thanks!
Dave


Try...

=REPLACE(A1,1,MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789"))-1,"")

Note that the formula will return the number as a text value. To
return the number as a numerical value, add +0 at the end of the
formula.

Hope this helps!