remove dot from text

[Mambaout626]

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

[José Augusto]

use the formula

Please Login or Register  to view this content.

[Mambaout626]

thanks, it works

[berlan]

and to remove all dots (if there are multiple dots in the cell), not just the first instance, excl the last parameter:

Please Login or Register  to view this content.

[Sam Capricci]

out of curiosity why not just use find and replace? Find . and replace leaving blank, replace all?