View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Rick[_10_] Rick[_10_] is offline
external usenet poster
 
Posts: 17
Default Extract portion of cell contents

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