Only returnig the text/numbers after a certain word in a cell

Hi all,

Please find attached a text sheet.

What I am looking for is a formula I cell C2 (and copy down) to return only the numbers after the Word "Number" in the Cell in column B, The issue is that there is not the same amount of words/letters before the word "number" so I am not sure how the LEFT function will work?

Thanks in advance for any help.

As on your last line there is no space between number and 668
=TRIM(RIGHT(B2,LEN(B2)-FIND("number",B2,1)-5))

or
=TRIM(RIGHT(B2,LEN(B2)-FIND("number",B2,1)-5))*1 if you want it as a number

Try this:

Please Login or Register  to view this content.

Found here: https://www.excelforum.com/excel-gen...xt-string.html

Easiest way is to use Flash Fill:

https://www.youtube.com/watch?v=qHkgJFJR5cM