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