A large quantity of data has been captured with units of measurement included in same cell as values. e.g. 65 kg or 1.2 metres

I have tried =AVERAGE(VALUE(LEFT(A13:A66,)))

But get a #VALUE error.

Please can someone explain how to property use the VALUE and LEFT functions or provide the correct formula.