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 EditPaste
SpecialValuesOKEsc


Gord Dibben MS Excel MVP


On Mon, 29 Jan 2007 10:04:02 -0800, sauceraus
wrote:

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