G Guest Jan 29, 2007 #1 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
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
G Guest Jan 29, 2007 #2 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
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
G Gord Dibben Jan 29, 2007 #3 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
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
E Earl Kiosterud Jan 29, 2007 #4 ss, If you want quote marks around the entire field, I think you could put them in your merge main document instead.
ss, If you want quote marks around the entire field, I think you could put them in your merge main document instead.
