View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default Question about copying column of cells and......

="(" & A1 & ")" and drag down to add parentheses to the entries in column A

Regards

Trevor


"WM" wrote in message
...
I am typing text in a column of cells (maybe 50 cells per column) with
various text in each cell of this column. Then in the next column I copy
that first column of text and have to manually add parenthesis to each and
every cell of the copied column. Is there a formula that exists where I
can
have parenthesis automatically added around the text in each cell of the
newly copied column? I hope my question is clear enough. Thanks in
advance
for your answer(s).
--
WM