Pull string of text from within a cell

[kac1125]

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:

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: 44. 78. 10758424. 2. A TAPE & TAPE SILLY SPOONPROOF 11OZ 2PK <tbody> </tbody>

<tbody>
</tbody>

I would also like to pull 10758424. Please let me know if you have any ideas.

 

[etaf]

is there any pattern to the text
will it always start at character 9
will it always end in a .
is it only 7 or 8 characters long
is it always numbers ?

 

[Jonmo1]

Adding to etaf's questions..

Is it always the 3rd set of characters in the cell (seperated by spaces) ?
Is it always either 7 or 8 digits, could it be more/less ? What are the low and high limits of the digit count?
Are there always . after the first 3 sets of characters ?

 

[kac1125]

Thank you both for looking at this!
they are always the third set of characters.
they are always either 7 or 8 digits long not shorter or longer.
They are always a number.
Hopefully this helps

Thanks!

 

[Jonmo1]

Try

=TRIM(MID(SUBSTITUTE(SUBSTITUTE(A1," ",REPT(" ",255)),".",""),255*2,255))

or this if the first 3 sets of characters always end with a .

=TRIM(MID(SUBSTITUTE(A1,".",REPT(" ",255)),255*2,255))

 

[kac1125]

Thanks! The second formula worked perfect!

 

[Jonmo1]

Glad to help, thanks for the feedback.