copy cells

B

biffula

I have a column of cells (in the thousands) that I need to add
'@1234.com' to. Cant figure out the way to do it. Any suggestions?
Thanks in advance.
 
K

Kevin B

Insert a helper column to the right of the column that needs the suffix added
to it and enter the following, changing the A1 in the formula to the starting
cell of your data column:

=A1&"@1234.com"

Copy this down the column as far as necessary and then do the following:

Copy the entire column of formulas and move to the first cell of original
column of data. Click EDIT in the menu and select PASTE SPECIAL. Click the
VALUES option button and then click OK. Your original values have been
replaced by the formula values. Delete the helper column that has the
formulas and you're back in business.
 
D

David Biddulph

The same way as when you asked the same question in the same group
yesterday.
 
Top