Hello
i have to extract numbers from a string in Col G (varying rows) the data looks like this
<colgroup><col></colgroup><tbody>
</tbody>
MID(LEFT(G80,FIND(",",G80)-1),FIND("=",G80)+1,LEN(G80)) returns the first part i.e. 760; 1610; 1610
what formula can I use to return (in Col I) the second occurrence i.e. 350; 50; 350
your help will really be appreciated.
i have to extract numbers from a string in Col G (varying rows) the data looks like this
<colgroup><col></colgroup><tbody> </tbody> |
<colgroup><col></colgroup><tbody>
</tbody>
MID(LEFT(G80,FIND(",",G80)-1),FIND("=",G80)+1,LEN(G80)) returns the first part i.e. 760; 1610; 1610
what formula can I use to return (in Col I) the second occurrence i.e. 350; 50; 350
your help will really be appreciated.