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