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:[TABLE="width: 475"]
<tbody>[TR]
[TD] 44. 78. 9745016. 4. A SXYF JNMOPLATED XYZZ 4OZ 1PK
[/TD]
[/TR]
[TR]
[TD]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:
[TABLE="width: 475"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]44. 78. 10758424. 2. A TAPE & TAPE SILLY SPOONPROOF 11OZ 2PK
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would also like to pull 10758424. Please let me know if you have any ideas.
<tbody>[TR]
[TD] 44. 78. 9745016. 4. A SXYF JNMOPLATED XYZZ 4OZ 1PK
[/TD]
[/TR]
[TR]
[TD]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:
[TABLE="width: 475"]
<tbody>[TR]
[TD][/TD]
[/TR]
[TR]
[TD]44. 78. 10758424. 2. A TAPE & TAPE SILLY SPOONPROOF 11OZ 2PK
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]
I would also like to pull 10758424. Please let me know if you have any ideas.