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