Vba code for remove extra full stops, and make sentence case.

Hi forum,

I am the regular reader of this forum. I have a worksheet which contains extra full stops, and exclamatory marks in specific cell range. I need a vba code to remove these extra full stops and remove exclamatory marks and special characters and make sentence case for AF2:AH12.
(please find attached file)

I don't know is possible or not........

Regards,
Nandkumar S.