On Dec 17, 4:32*pm, "Rick Rothstein"
wrote:
Assuming the ID always comes at the end of the text (as you example
shows)...

=MID(A1,FIND("=",A1)+1,99)

--
Rick (MVP - Excel)

"Rick" wrote in message

...



Have a text string that could look something like this:
http://he4.clientthirddheytrs.com/wyt/cftts/edit.aspx?id={840102F6-AJUE-SD1B-9705-00188B2E03D9}

I need to extract the ID number which is surrounded by "the brackets".
Desired result in this instance would be:
{840102F6-AJUE-SD1B-9705-00188B2}

There is no consistency in the data; there can be any number of
characters between the brackets, and any number of characters before,
or after the brackets. *It's all formatted as text.

Ideas?
Thanks in advance.
Rick- Hide quoted text -

- Show quoted text -

Rick, Oops. There will be instances where characters will appear
after the last bracket. I appologize for the poor example.
Those need to be stripped off as well. Want to take another run at it?
Thanks again for your assistance.
Rick