Catatenate quotes to excel field 2

[ChrisBurch]

Hi all,

I'm outputing a csv file from Excel 97. However, I need to wrap 1 text field in quotes. I can concatenate any other character to the field okay, but can't find a way to add the " symbol. I've tried wrapping it in single qoutes, but suspect I should be using a chr string. Can anyone give the correct syntax for:-

Cells(1,1) = """ & Cell(1,1) & """

Thanks, Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[DaleWatson123321]

Hi Chris,

=CHAR(34) will give you the double quote ( " ) character.

Hope this helps. Please advise as to whether this works in your situation.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[ChrisBurch]

thanks Dale,

Is there a trick to using CHAR() ? VBA complains that it's an undefined sub or function.

Thanks Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[ChrisBurch]

Okay, problem solved. I used chr(34) and it worked a treat, thanks a lot. I'm still confued with CHAR(34) though, Excel help say's it's legit, but the compiler still complains that is undefined....what am I missing? Chris

It worked yesterday.
It doesn't work today.
That's Windows!

 

[Tiglet]

Dale,

I was looking for a solution to this and found it on a search - have a star!

Where does the CHAR function point to - it says in the fx list that it returns the character specified by the code number in your computer - where are these specified?

Many Thanks

Tiglet

Living on Earth is expensive, but it does include a free trip around the sun every year