Substitute a "

E

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.
 
Q

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
 
Top