Looking for how to do a double FIND formula
 

I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255 with
that number?

One way

=MID(A1,FIND("{",A1)+1,FIND("}",A1)-FIND("{",A1)-1)

--
Regards,

Peo Sjoblom

(No private emails please)


"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255 with
that number?

=MID(A2,FIND("{",A2)+1,FIND("}",A2)-FIND("{",A2)-1)

Philippe L. Balmanno wrote:
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255 with
that number?



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.

=MID(A1,FIND("{",A1),FIND("}",A1)-FIND("{",A1)+1)

includes the Braces, This is the text between:

=MID(A1,FIND("{",A1)+1,FIND("}",A1)-FIND("{",A1)-1)

--
Regards,
Tom Ogilvy

"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however
the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255
with
that number?

"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }. I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255 with
that number?
Thank you I just had a small modification to include the start & end
characters.
=MID(A1,FIND("{",A1)-1,FIND("}",A1)-FIND("{",A1)+2)

That includes an extra character before the {

--
Regards,
Tom Ogilvy


"Philippe L. Balmanno" wrote in message
news:OYVxe.41891$go.31808@fed1read05...
"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }.
I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however
the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255
with
that number?
Thank you I just had a small modification to include the start & end
characters.
=MID(A1,FIND("{",A1)-1,FIND("}",A1)-FIND("{",A1)+2)

"Tom Ogilvy" wrote in message
...
That includes an extra character before the {

--
Regards,
Tom Ogilvy


"Philippe L. Balmanno" wrote in message
news:OYVxe.41891$go.31808@fed1read05...
"Philippe L. Balmanno" wrote in message
news:5rVxe.41887$go.33565@fed1read05...
I have a cells in column A in varying lengths that I want to extract the
text characters in between two known and common characters { and }.
I've
tried figuring out the use of =MID(A:A,FIND("{",A:A&"}")-1,255) however
the
string of characters within { and } varies in length. Is there a way to
count the characters in between my search criteria and replace the 255
with
that number?
Thank you I just had a small modification to include the start & end
characters.
=MID(A1,FIND("{",A1)-1,FIND("}",A1)-FIND("{",A1)+2)



Yes it's a space