remove dot from text

[Excelguru2015]

Hi guys,

I have the following names:

Col A1: Apple Inc.
Col B1:Banana Pte
Col C1: Coconut Ltd

any formula to remove the dot from the text if the cell value contains a dot?

end result: Apple Inc


I have 1000plus names and I want to standardised the name format. Hence I need a formula to delete the dot away from if the cell contains a dot

thanks,
Alex

 

[gaz_chops]

Highlight data, select Ctrl F, enter a dot. then Replace, leave it blank, replace all, ok.