View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave F Dave F is offline
external usenet poster
 
Posts: 2,574
Default add quotation marks to each cell in a column

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
--
Brevity is the soul of wit.


"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