add info to column

  • Thread starter Thread starter jj348206
  • Start date Start date
J

jj348206

I have a list of over 1000 names in my a column but need to add @gmail.com to
the end of all of them. How can i do that in excel?
 
HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John
 
Assume names running in A2 down
In B2: =IF(TRIM(A2)="","",TRIM(A2)&"@gmail.com")
Copy down all the way. Then if desired, kill/freeze col B with an "in-place"
copy n paste special as values. Any joy? hit the YES below.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
 
How do i copy down?
Easiest way is to drag the cell's fill handle down, ie point the cursor at
the bottom right hand corner of the 1st formula cell (ie B1), then drag down.
When you point the cursor at the cell's fill handle, it looks like a solid
little black square. Any joy? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
 
I would say the easiest way to copy down is to double-click the fill handle
if there is data in the adjacent column...........which there is in this
case.


Gord Dibben MS Excel MVP
 
Back
Top