But if for some reason you insist on using MID:
=MID(A1,LEN(A1)-2,3)

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary" wrote in message ...
| For example in B1 write :-
|
| =RIGHT(A1,3)
|
| i hope that helps.
|
| GARY
|
| "Gary" wrote in message
| ...
| Try using RIGHT instead of MID
|
|
| "nsv" wrote in message
| ...
|
| The MID function works from left to right so picking the first three
| characters of a string is easy enough, but I need to pick the LAST
| three characters of a series of strings with variable length.
|
| Is it possible to do this?
|
| NSV
|
|
| --
| nsv
| ------------------------------------------------------------------------
| nsv's Profile:
| http://www.excelforum.com/member.php...o&userid=26500
| View this thread:
| http://www.excelforum.com/showthread...hreadid=566959
|
|
|
|
|