Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
=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. |
#4
|
|||
|
|||
=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? |
#5
|
|||
|
|||
"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) |
#6
|
|||
|
|||
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) |
#7
|
|||
|
|||
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Can't find the right lookup formula for this | Excel Worksheet Functions | |||
IF & VLOOKUP FORMULA | Excel Worksheet Functions | |||
Relative Indirect Formula Referencing? | Excel Worksheet Functions |