extracting data based on text

**nobodytwok** · 03-15-2013, 09:24 AM

dear all,

i'm facing a list of toooo many lines.

every now and then I have a line with the content:

Please Login or Register  to view this content.

and I would need to extract the data between Duration: and "s"
in this example I would need the "189".

side infos:
its not always 3 digits long (can def. from 1 to 5 digits)
and the line with "duration" in it is in every 3rd to 5t line.

looking forward to any assistance - thank you all in advance.

thanks and have a nice day,

twok

**benishiryo** · 03-15-2013, 09:37 AM

hi twok, welcome to the forum. maybe something like this:
=MID(A1,FIND(":",A1)+2,FIND("s",A1)-FIND(":",A1)-2)

the above will be a text. so if you need it as a number
==MID(A1,FIND(":",A1)+2,FIND("s",A1)-FIND(":",A1)-2)+0