| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Substitute/Replace | Charts and Charting in Excel | |||
| Replace or Substitute for COMBIN function | Excel Discussion (Misc queries) | |||
| Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
| Exporting single or double quote delimited files | Excel Worksheet Functions | |||
| how do I create comma and double quote delimited file | Excel Discussion (Misc queries) | |||
Hybrid Mode
