I have data in column like this.
50
50/152
[Blank]
56
150/150
20
[Blank]


I want only single numerical or blank in cell. For that I need average of 50/152.

I am using formula =(LEFT(A1, FIND("/",A1)-1) + MID(A1, FIND("/",A1)+1, 100)) / 2 for that.
But How can I use it with IF so that I can apply to whole column?

Question is - To remove punctuation mark from data & make it clean. Than keep only single numerical digit. What to do if there is any other punctuation mark in cell?