Summing Data with Data

[howard]

I have data in Col F from row 2 as follows



31 Days
45 Days
65 Days
39 Days Etc


I will like a formula to average these


Your assistance is most appreciated

 

[MARZIOTULLIO]

	F​	G​
1​		average
2​	31 Days	45​
3​	45 Days
4​	65 Days
5​	39 Days

<tbody>
</tbody>

g2=AVERAGE(SUBSTITUTE(F2:F5,"Days","")+0) control+shift+enter

 

[howard]

Thanks for the help, much appreciated

 

[MARZIOTULLIO]

you are welcome