MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Removing quotes ("") from a text string


Posted by G on September 18, 2000 2:28 PM

How do I Replace/Substitute for quotation marks in a text string? Typically, I place quotes around what I want to remove...what do I do when I actually want to remove the quotes themselves?

I've tried =substitute(a1,"""," ") but it doesn't seem to work. Is there a special character/number that denotes quotes?

TIA
-G


Posted by yaneckc on September 19, 0100 11:47 AM

G

HIGHLIGHT THE CELL OR CELLS CONTAINING THE QUOTATION MARKS THAT YOU WANT TO BE REPLACED WITH SPACES. THEN GO TO EDIT REPLACE. IN FIND WHAT: " (ENTER ONLY ONE QUOTATION MARK) IN REPLACE WITH: (ENTER ONE SPACE) THEN CLICK REPLACE ALL

YANECKC

Posted by Tim Francis-Wright on September 18, 0100 2:55 PM

A double quote is CHAR(34), so to replace
any double quote with a space, try
=SUBSTITUTE(a1,CHAR(34)," ")

HTH