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.

try

Please Login or Register  to view this content.

jindo,

thanks,

but this code is not working for it.

I want remove special characters in the cells, remove extra .......... and making sentence case for text in the cell.

Regards,
Nandkumar S.

Then show me your desired results.

Dear Jindon,

thanks for replying,

if cell contain below text

this is+ EXAMPLE! text.........

I want Result>>

This is example text.

Regards,
Nandkumar Satpute

Try change to

Please Login or Register  to view this content.

If this doesn't do what you expected, need to see the data in workbook with before/after format.

Dear Jindon,

thanks for giving interest in my thread,

but this code is not working. Find attached file beginning of the thread and pls check at your side.

very thanks to you........

Regards,
Nandkumar S.

There's no results that you wanted, so I will leave here.

Good luck.

Abybody can help.......