Thread: How can the SUBSTITUTE function replace a double quote?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
[email protected] robotman@gmail.com is offline
external usenet poster
  
Posts: 73
Default How can the SUBSTITUTE function replace a double quote?
Use CHAR(34) everywhere you want a double-quote:

Example:

=SUBSTITUTE(G14,CHAR(34),"#")


Reply With QuoteReply With Quote