Replacing quotes in a cell with "

[mdonahoe]

Hi,

I'm working on a workbook that when a user types into a worksheet a
second hidden sheet will be produced using FIND and REPLACE formulas
that will eliminate commas, apostrophes, and quotes and replace them
with the ISO-Latin-1 Charachter Set. So far this has been relatively
easy except for building a formula to replace a quotation mark (") with
it equivalent ( " ). Since Excel uses the quotation mark as a
text qualifier. Anyone know how to get the FIND function to locate a
quotation mark?

Thanks,

Mike

 

[mdonahoe]

Nevermind, I found it by mistake - needed 4 quotes....?...well it works
anyway

 

[Dave Peterson]

I think???? you want want something like:

=FIND("""",A1)
or maybe:
=FIND(CHAR(34),A1)

Or maybe:

=SUBSTITUTE(A1,"""",""")
or
=SUBSTITUTE(A1,char(34),""")