View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Per Jessen Per Jessen is offline
external usenet poster
 
Posts: 1,533
Default extract last 2 characters from the right?

Hi Pierre

Try this:

=MID(A1,LEN(A1)-1,2)

Regards
Per

"Pierre" skrev i meddelelsen
...
Need to obtain in one cell the 2 right most characters from another
cell. Can anybody here help with a formula?

in other words:
A1=ASW232.1
result would be: .1

Thanks in advance.
Pierre