Thread: How can the SUBSTITUTE function replace a double quote?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
T. Valko T. Valko is offline
external usenet poster
  
Posts: 15,768
Default How can the SUBSTITUTE function replace a double quote?
Use 4 double quotes: """"

A1 = "Biff"

=SUBSTITUTE(A1,"""","")

returns: Biff

Biff

"Florence" wrote in message
...
I'm trying to use the SUBSTITUTE function to replace a double quote (")
with
a regular text. The function works well with other special characters but
not the double quote.


Reply With QuoteReply With Quote