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
|