View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Dave Dave is offline
external usenet poster
 
Posts: 1,388
Default Remove Numbers from Alphanumeric String

Thanks Farhad. This works, but my string does not always have 3 digits. Some
are 4 or 5 digits.

"Farhad" wrote:

Hi,

Try this:

=RIGHT(A1,3)

Thanks,
--
Farhad Hodjat


"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