Implementing a formula

**vanthetsar** · 06-30-2015, 07:06 AM

Hi everyone I have a file with different cells with this same kind of information:

<blurb-image alt="Dyson" type="local" value="_home_and_kitchen/logos/dyson_120x50.png"><image-link type="search" value="rh=i%3Akitchen%2Cn%3A524015031%2Cn%3A!524016031%2Cn%3A731679031%2Cn%3A732998031%2Cp_89%3ADyson%2Cn%3A733009031&bbn=732998031&rw_html_to_wsrp=1"/></blurb-image>

I need to extract in the column next to them the following string from it:

rh=i%3Akitchen%2Cn%3A524015031%2Cn%3A!524016031%2Cn%3A731679031%2Cn%3A732998031%2Cp_89%3ADyson%2Cn%3A733009031&bbn=732998031&rw_html_to_wsrp=1

Any ideas on how can I achieve this?

**oeldere** · 06-30-2015, 08:47 AM

a2 =Left(Right(A1,LEN(A1)-(search("rh=i",A1,1)-1)),LEN(Right(A1,LEN(A1)-(search("rh=i",A1,1)-1)))-17)

**vanthetsar** · 06-30-2015, 09:04 AM

Originally Posted by oeldere

a2 =Left(Right(A1,LEN(A1)-(search("rh=i",A1,1)-1)),LEN(Right(A1,LEN(A1)-(search("rh=i",A1,1)-1)))-17)

Thanks, your formula work quiet alright!

**oeldere** · 06-30-2015, 09:14 AM

You're welcome. We appreciate the feedback!

If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.

Thanks for the rep.