I need a formula that I can copy down to pull a string of text from within cells. for example, I have the following text in a cell:
<tbody>
</tbody>
I would also like to pull 10758424. Please let me know if you have any ideas.
44. 78. 9745016. 4. A SXYF JNMOPLATED XYZZ 4OZ 1PK | ||
I want to pull 9745016 from within that cell. This string is 7 digits long. In addition I would like the formula to be able to copy down and and be able to pull an 8 digit string as well from it as well. for example:
<tbody> </tbody> |
<tbody>
</tbody>
I would also like to pull 10758424. Please let me know if you have any ideas.