I need to add a parenthesis in front of and behind a column of email address's. ??
A a_dallas_boy Feb 17, 2005 #1 I need to add a parenthesis in front of and behind a column of email address's. ??
P Peo Sjoblom Feb 17, 2005 #2 You can use a help column and a formula like ="("&A2&")" copy down and then copy and paste special as values, finally you can paste it over the old values if needed in the above example A2 would hold the first value you want to change
You can use a help column and a formula like ="("&A2&")" copy down and then copy and paste special as values, finally you can paste it over the old values if needed in the above example A2 would hold the first value you want to change
G Gord Dibben Feb 17, 2005 #3 Assuming column A has addresses. In B1 enter ="(" & A1 & ")" Double-click on the B1 fill handle to copy down. When happy, Copy column B and Paste Special(in place)>Values>OK>Esc. Delete column A. Gord Dibben Excel MVP
Assuming column A has addresses. In B1 enter ="(" & A1 & ")" Double-click on the B1 fill handle to copy down. When happy, Copy column B and Paste Special(in place)>Values>OK>Esc. Delete column A. Gord Dibben Excel MVP
