add info to column

[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?

 

[John]

HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John

 

[Max]

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

 

[jj348206]

How do i copy down?

HI
Lets assume your list is starting at A1, just type in B1 =A1&"@gmail.com"
and copy down to A1000.
HTH
John


.

 

[Max]

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
---

 

[Gord Dibben]

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