Place quotes in cells

[impulse24]

Hi,

I have an excel spreadsheet, and I want to wrap a piece of text with quotes in a cell, but I can't get excel to let me do this. Please help..Is there some type of escape character that I need to enter?

 

[impulse24]

I know I can add an apostrophe to have the quote displayed in Excel, but I need to save the file out to a text file, and when I do it adds 4 quotes for the single quote I entered in Excel.

 

[Zathras]

Excel uses first character to differentiate between numbers and text.

A1: "This is right-justfied with one trailing double quote"
A2: 'This is left-justified
A3: '"This is left-justified in quotes"

Now, if you are talking about using quotes in formulas, that is a different problem. Since the double-quote is used to delimit pieces of string, you need two double quotes in a row whenever you need a double quote.

A4: ="This is a ""funny"" way to do it" & " but it works."

As an alternative you can also use the formula: Char(34).

 

[Zathras]

We were posting at the same time.

That is a different problem. Try saving the file as type "Formatted Text (Space delimited) (*.prn)"

Put the whole file name in quotes (!) to keep Excel from adding .prn as an extension. E.g. "myfile.txt"

If you just leave it as myfile.txt Excel will write it as myfile.txt.prn and you can rename it (after leaving Excel, since it keeps a lock on it).