if i interpret your request correctly, i think this is what you need

=MID(A1,LEN(A1)-5,4)

--


Gary


"owl527" wrote in
message ...

Hello,

how do I pick up a cell (with strings) and extract 4 characters from
the 5th character from right side of the string. What function can I
use?

Please let me know. Thanks.


--
owl527
------------------------------------------------------------------------
owl527's Profile:
http://www.excelforum.com/member.php...o&userid=20916
View this thread: http://www.excelforum.com/showthread...hreadid=482103