looking at your request again, i'm not sure what you want. if there are 10
characters, and you want the 5th from the right, you would want the 6th,
7th, 8th and 9th characters.

this would do that

=MID(A1,LEN(A1)-4,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