Help with formula for extracting number value in cells that contains both text and number

Hi !
I am working with a workbook where i have a worksheet where i want to extract a numerical value from another sheet rows/cells that contains both numbers and text.
The sheet i need to get the values from has from 1000 rows and up to 5000 rows where data is imported and paste to cells in comumn A, this results in both text and numbers in the same cell.
I need to find the cells containing part of specific text, extraxt the numerical value and summarize all, then divide on amount of rows containing the part of specific text to get an average value.

Attached a sample sheet

Regards:
Jan Ovecount extraxtion.xlsm

Originally Posted by Glenn Kennedy

I think you may have given us a very poor sample.

after "part of specific text = "1404.52 Liters.

Is that " ACTUALLY present in the cells?, no i added them for showing wich part of specific text to look for.

Is there ALWAYS only one number in the text?, no there is also other numbers like time and date.

Is there ALWAYS only one word after the number?, Yes the word after the numbers i need to extract is always one.

Is it ALWAYS Liters?, Yes the number i need will always end with Liters.

Hi !
sorry if the sample i provided was confusing..

Regards:
Jan Ove