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