Geek asks and answers

Special character replacement

Is it possible to delete a character "using an Excel formula?

I tried REPLACE function like this

REPLACE(<sometext>, """, "")

and this one

REPLACE((<sometext>, char(34), "")

but that will not work.

NB: I am using the Polish version of Excel, so it is likely that the syntax is different from the English version. For example, in Polish formulas we use ;instead ,as a separator of arguments.

+3
source share
2 answers

The quote character "must be represented by two of them ""when it is inside the string in order to rotate the ambiguity between this “text” quote and “code” quotes that limit the beginning and end of your string.

, " A1:

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

, old_text """" ( ), """ ( ), .

, SUBSTITUTE Replace ? , SUBSTITUTE (; ,).

+6

, .
SUBSTITUTE.

=SUBSTITUTE(A1, CHAR(34), "-")

;

=SUBSTITUTE(A1; CHAR(34); "-")
+2

More articles:


All Articles