add quotation marks to each cell in a column

[Guest]

I am trying to add quotation marks around the text in cells in a column.
This is to help with a mail merge that I am doing.

Thanks.
ss

 

[Guest]

Assuming the cell in question is A1: =concatenate(""",A1,""")

Note that there are three double quotation marks on either side of the A1
reference.

Dave

 

[Gord Dibben]

One method assuming column of text is A

=""""&A1&"""" (that's 4 each of ") entered in B1

Copy down column A

When happy with results, copy Column B and in place Edit>Paste
Special>Values>OK>Esc


Gord Dibben MS Excel MVP

 

[Earl Kiosterud]

ss,

If you want quote marks around the entire field, I think you could put them
in your merge main document instead.