How can the SUBSTITUTE function replace a double quote?
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. |
Answer: How can the SUBSTITUTE function replace a double quote?
The SUBSTITUTE function in Excel can be used to replace a specific character or text string with another character or text string. However, when it comes to replacing a double quote ("), there is a bit of a trick to it.
Here's how you can use the SUBSTITUTE function to replace a double quote:
Here's an example of how the function would look if you wanted to replace a double quote with the text "replace": Code:
=SUBSTITUTE(A1, """", "replace") |
How can the SUBSTITUTE function replace a double quote?
TRY:
=SUBSTITUTE(A1,"""","your_text*") "Florence" wrote: 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. |
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. |
How can the SUBSTITUTE function replace a double quote?
Try this:
=SUBSTITUTE(A1,CHAR(34),"xxx") With the string "Hello" in A1, this returns xxxHelloxxx Hope this helps. Pete On Feb 27, 7:06 pm, Florence wrote: 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. |
How can the SUBSTITUTE function replace a double quote?
Use CHAR(34) everywhere you want a double-quote:
Example: =SUBSTITUTE(G14,CHAR(34),"#") |
How can the SUBSTITUTE function replace a double quote?
Florence wrote...
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. A1: "This" is a "test". A2: =SUBSTITUTE(A1,"""","|") returns |This| is a |test|. A3: =SUBSTITUTE(A1,CHAR(34),"|") returns |This| is a |test|. |
All times are GMT +1. The time now is 05:18 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com