| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? . |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 --- |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to update column info based on column info from another worksh | Excel Discussion (Misc queries) | |||
| Lookup info in one Column and then returning info in other columns | Excel Worksheet Functions | |||
| Referencing date column A & time column B to get info from column | Excel Discussion (Misc queries) | |||
| How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
| Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
Linear Mode
