One way
=MID(A1,FIND("{",A1)+1,FIND("}",A1)-FIND("{",A1)-1)
--
Regards,
Peo Sjoblom
(No private emails please)
"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255 with
that number?
|