Substitute a "

[Electra]

I want to use the Substitute function to replace a " with a blank.
The following works: =substitute('***',"'","") this resolves to ***
single quote marks are removed no problem.

However the following won't work: =substitute("***",""","").

I have colunm full of text data that are all enclosed in quote marks.
I want to write a formula to remove quote marks. I don't want to use
the find and replace feature to do this.

 

[Quandan - Marcel Kreijne]

I guess you should use CHAR(34) in stead of """

Kind regards,

Marcel Kreijne
Quandan - Steunpunt voor spreadsheetgebruikers
(Quandan - Dutch supportsite for spreadsheetusers)
www.quandan.nl