FIND character function and extracting data

[moe10134]

Hello,

I am inquiring about a FIND formula or something different that will help me find the 3rd or 4th place of a specific symbol instead of having to count the number of letters including spaces to get the total character number I need. Does anyone know a formula that I can recognize the third "=" in the following statement?

Here is an example of the text in A1: <img width="640" alt="B67301_RED" src="https://embed.radar.net/img/cnh/tekufl67v6/640px/B67301_RED.jpeg?u=js6tkf">

Normally, I would have a formula in cell A2 [=FIND("=",A1,36)] meaning that the third "=" is the 36 character in the A1 text. But, Not all "=" are the 36th character when doing an =FIND in different text.

In multiple cells I would do a =LEN formula in cell A3 and generate a count of the different from the =FIND and =LEN. Then using a =RIGHT formula to extract the total number of characters from the subtraction formula leaving everything from the third "=".

Here is an example of the text in A1: (i mg width="640" alt="B67301_RED" src= "https://embed.radar.net/img/cnh/tekufl67v6/640px/B67301_RED. jpeg?u=js6tkf")

(*Have to add additional space characters to the URL because of HTML coding in this message.)

A2 = [=FIND("=",A1,35)] = 37
A3 = LEN(A1) = 113
A4 = subtracting the difference from A3-A2 Formulas = 75
A5 = [=RIGHT,A1,A4)


I'm looking for something that will provide me with finding the third "=" in the text in cell A1. I am basically looking to extract the text: [https://embed.radar.net/img/cnh/tekufl67v6/640px/B67301_RED.jpeg] from the following original text in A1. There are 3 "=" signs and I need to extract everything after that third "=". I can do a Find/Replace or = SUBSTITUTE formula to get rid of the [?u=js6tkf">] text at the end.

But, If anyone knows a formula that will extract the text: [https://embed.radar.net/img/cnh/tekufl67v6/640px/B67301_RED.jpeg] from the example text no matter how long the text is and what number character the third "=" is, along with even eliminating the [?u=js6tkf">] at the end would be great.

Any suggestions? Thank you kindly!

 

[Jonmo1]

Try this

=REPLACE(A1,1,FIND("^",SUBSTITUTE(A1,"=","^",3)),"")

The ^ can be any character (or string of characters) you choose that is least likely to actually appear in the original string.

 

[moe10134]

Try this

=REPLACE(A1,1,FIND("^",SUBSTITUTE(A1,"=","^",3)),"")

The ^ can be any character (or string of characters) you choose that is least likely to actually appear in the original string.

Thank you very much! This is a great help. This will save me a lot of time. =)

 

[Jonmo1]

You're welcome.