Or event this approach using the two curly brackets as you suggest, but
using a simpler construction than the OP's found solution (still using MID,
but using a much larger number of character)...

=MID(LEFT(A1,FIND("}",A1)),FIND("{",A1),999)

--
Rick (MVP - Excel)


"Rik_UK" wrote in message
...
Rik

I would suggest the following amendment as an enhanced version of the
formula

=LEFT(MID(A1,FIND("{",A1),LEN(A1)),FIND("}",MID(A1 ,FIND("{",A1),LEN(A1))))

this simplifies things slightly, and in your original post you said the
number of characters between the brackets is not fixed... so this removes
the
limitation of 99 characters, as you have currently got.

Hope this is ok...

--
If this is the answer has helped please remember to click the yes button
below...

Kind regards

Rik


"Rick" wrote:

On Dec 18, 5:52 am, Rick wrote:
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


Rick: found one that works after poking around the archives for
similar formulas,a dn utilizing your formula and inspiration. . .

=LEFT(MID(A1,FIND("=",A1)+1,99),FIND("#",MID(A1,FI ND("=",A1)+1,99))-1)

First bracket is always preceeded by a =, and last bracked is followed
by a #.


Many many thanks.
Rick


.