Extract Data from between 2 characters

[oscarneill]

Hi guys i have added a link to a spreadsheet. It has 2 columns in it. I want to extract particular information from within the load of code in that field. The information i want to extract is in the second link.



Could you put the data between those characters and put it in cell C2

Spreadsheet Link: https://www.dropbox.com/s/rrt6ehc27ih7nsn/Data.xlsx?dl=0
Data to extract from Cell: https://www.dropbox.com/s/az46kcj5igas3zm/data to extract.txt?dl=0

Thanks for the help hope you come up with a formula for this

 

[Michael M]

Why not simply post a small before and after sample directly to the forum....rather than posters having to download / open 2 sites

 

[oscarneill]

its HTML code so everytime i put it into the forum it removed the code and formatted it. Thats why i have done it this way.

 

[sanrv1f]

something like this?

C2

=MID(B2,SEARCH("< div",B2),SEARCH("< / div",B2)-SEARCH("< div",B2)+6)

ps: remove the spaces in the formula after copying to excel<div",b2),search("< div",b2)-search("<div",b2)+6)[="" code]<="" html=""></div",b2),search("<>

 

[sanrv1f]

Not sure I understood the requirment correctly, there are lot of "div" and "/div"s, based on what character you want to cut the data?

 

[oscarneill]

Not sure I understood the requirment correctly, there are lot of "div" and "/div"s, based on what character you want to cut the data?

Based on these characters

Start: < div class=\""desc\"" >
Finish: < / div>

remove spaces

 

[sanrv1f]

try this

=MID(B2,SEARCH("< div class=\""desc\"" >",B2),SEARCH("< /div",MID(B2,SEARCH("< div class=\""desc\"" >",B2),LEN(B2)))+5)

 

[oscarneill]

Solved.