Quotation Marks as Text


Kelly C

Quotation marks as text

I am using Excel’s IF Function to generate text that will be used in another
application. The text will be savedd to Tab delimited file and then imported
into the new application. That new application requires text strings be
enclosed in quotation marks. The problem is I can’t get Excel’s IF formula
to accept Quotation marks within Quotation marks or stated another way I
can’t get Quotation Marks as part of my text string. Is there a way to get
around this?


Per Jessen

Hi Kelly

Look at this example:


Hopes it helps.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question