add info to column
 

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?

add info to column
 

HI
Lets assume your list is starting at A1, just type in B1 "
and copy down to A1000.
HTH
John
"jj348206" wrote in message
...
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?

add info to column
 

Assume names running in A2 down
In B2: ")
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" wrote:
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?

add info to column
 

How do i copy down?
"John" wrote:

HI
Lets assume your list is starting at A1, just type in B1 "
and copy down to A1000.
HTH
John
"jj348206" wrote in message
...
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?

.

add info to column
 

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

add info to column
 

Oops, clarification ...
The cell's fill handle looks like a solid little black square
When you point at it the cursor changes into a cross
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---

add info to column
 

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

On Wed, 25 Nov 2009 13:53:02 -0800, Max wrote:

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