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
|