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

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