Question about copying column of cells and......
 

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

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

Question about copying column of cells and......
 

I'm sorry Trevor, can you clarify the formula? If I have in Column A the
following

A1 has 2-TBA-13
A2 has 2-TBA-26
A3 has 3-TBC-35

I will copy the text in A1, A2 and A3 over to B1, B2 and B3 but in the B
column, that text needs parenthesis. Can you explain the formula better?
Forgive me for not understanding and I really appreciate your answer. I'm
just not sure of exactly how to enter the formula. THANK YOU.
--
WM


"Trevor Shuttleworth" wrote:

="(" & 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

Question about copying column of cells and......
 

Don't copy anything.

In cell B1, put the formula: ="(" & A1 & ")" and drag down

So, in cell B1, you need to type an equals sign (=), followed by double
quotes ("), open parenthesis ((), double quotes ("), an ampersand (&), A1
(which picks up the value in the cell A1), an ampersand (&), double quotes
("), close parenthesis ()), and double quotes (")

If you want to end up with values instead of formula, select the whole of
column B, Copy it and then select PasteSpecial | Values

Regards

Trevor


"WM" wrote in message
...
I'm sorry Trevor, can you clarify the formula? If I have in Column A the
following

A1 has 2-TBA-13
A2 has 2-TBA-26
A3 has 3-TBC-35

I will copy the text in A1, A2 and A3 over to B1, B2 and B3 but in the B
column, that text needs parenthesis. Can you explain the formula better?
Forgive me for not understanding and I really appreciate your answer. I'm
just not sure of exactly how to enter the formula. THANK YOU.
--
WM


"Trevor Shuttleworth" wrote:

="(" & 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

Question about copying column of cells and......
 

Thank you Trevor. I appreciate your help very much.
--
WM


"Trevor Shuttleworth" wrote:

Don't copy anything.

In cell B1, put the formula: ="(" & A1 & ")" and drag down

So, in cell B1, you need to type an equals sign (=), followed by double
quotes ("), open parenthesis ((), double quotes ("), an ampersand (&), A1
(which picks up the value in the cell A1), an ampersand (&), double quotes
("), close parenthesis ()), and double quotes (")

If you want to end up with values instead of formula, select the whole of
column B, Copy it and then select PasteSpecial | Values

Regards

Trevor


"WM" wrote in message
...
I'm sorry Trevor, can you clarify the formula? If I have in Column A the
following

A1 has 2-TBA-13
A2 has 2-TBA-26
A3 has 3-TBC-35

I will copy the text in A1, A2 and A3 over to B1, B2 and B3 but in the B
column, that text needs parenthesis. Can you explain the formula better?
Forgive me for not understanding and I really appreciate your answer. I'm
just not sure of exactly how to enter the formula. THANK YOU.
--
WM


"Trevor Shuttleworth" wrote:

="(" & 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