Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extract portion of a cell | Excel Discussion (Misc queries) | |||
How to use/extract only a portion of a field | New Users to Excel | |||
Extract a specific portion of text as new cell value | Excel Discussion (Misc queries) | |||
Extract portion of formula resident in a cell | Excel Worksheet Functions | |||
I need to search for then extract a specific portion of cell data... | Excel Worksheet Functions |