Quote Originally Posted by Fluff View Post
How about
=LEFT(MID(A1,27,LEN(A1)),FIND("21",MID(A1,27,LEN(A1)))-1)
I'm sorry, this did not work. It came up as #VALUE !.