copy cells

  • Thread starter Thread starter biffula
  • Start date Start date
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.
 
=A1&"@1234.com" and copy down. If you don't need to keep the original you
can Copy, Edit/ Paste Special/ Values, and delete the unwanted column.
 
One eqasy way is to use an auxilary column to add the suffix and then copy
the new colum back to the old column.

If your data is in Column A but in to column B
=A1 & "@1234.com"

then copy formula down the entire column B. Then you can copy this new row
back to the old row.
 
Back
Top