mohanprabhus
New Member
- Joined
- Dec 7, 2016
- Messages
- 17
Hi All,
I have my text data as below mentioned & i need to extract data
<tbody>
</tbody>
but i want like this, Can you helpme with this format And provide the formula to update.
I have extracted last one by using formula (=MID(H2,FIND("|",SUBSTITUTE(H2,",","|",LEN(H2)-LEN(SUBSTITUTE(H2,",",""))))+1,500) ), but do no to extract in between text and numbers.
<tbody>
</tbody>
I have my text data as below mentioned & i need to extract data
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> | |
<tbody> </tbody> |
<tbody>
</tbody>
but i want like this, Can you helpme with this format And provide the formula to update.
I have extracted last one by using formula (=MID(H2,FIND("|",SUBSTITUTE(H2,",","|",LEN(H2)-LEN(SUBSTITUTE(H2,",",""))))+1,500) ), but do no to extract in between text and numbers.
152/C Ist FLOOR, ASAMBU ROAD | VADASERRY | NAGERCOIL | 629001 | TAMIL NADU | |||||
21-37-L, I FLOOR | VASANTHAM MAIN ROAD | THUCKALAY |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | |||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> | ||||||
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody> </tbody> |
<tbody>
</tbody>