How to remove special char ' in my string ?

[varunvarma]

Hello All,

How to remove special char ' in my string.

EG :- I have data like this

INDI'A

CHI'NA

SINGAP'ORE

Here i want to remove symbol ' and my output should be like this

INDIA

CHINA
SINGAPORE

I am using REPLACE function and it is working for symbols like .,-  but not working for '   Please let me know how to do this.

Thanks in advance.

[varaprasad0816]

Correct