Extract portion of cell contents
On Dec 18, 12:26*pm, "L. Howard Kittle" wrote:
Hi Rick,
Here's one more just for fun.
=MID(A4,FIND("{",A4)+1,FIND("}",A4)-FIND("{",A4)-1)
HTH
Regards,
Howard
"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 -
You guys are awesome!
Thank you so much for your efforts on this.
Rick
|