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