 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
07-08-2008, 08:47 PM
|
|||
|
|||
|
Help, please, adding on to items in a column...
Hi...
I've tried, no luck, redefining contents of cells in one single column.... and would like to ask your help! Column F is a truncated listing of email addresses (A thru E, name, tel, region, etc). However, this column only contains 'jdoe', which is their first initial and last name- which is how the email system is set up..(jgarcia, rstarr, etc!). All of these are '@xyz.com'. Is there some way to add the ' @xyz.com' to what is already contained? I tried defining as special, but that hasn't worked... Unless I'm doing it wrong?? thank you! -- B'rgds, Vinnie 
|
|
07-08-2008, 09:38 PM
|
|||
|
|||
|
Re: Help, please, adding on to items in a column...
=cellref & "@xyz.com"
Copy down then select column and in place, copy>paste special>values>ok>esc Gord Dibben MS Excel MVP On Tue, 8 Jul 2008 15:47:21 -0400, "Uncle Vinnie" <vinrin57@optonline.not.net> wrote: >Hi... > >I've tried, no luck, redefining contents of cells in one single column.... >and would like to ask your help! > >Column F is a truncated listing of email addresses (A thru E, name, tel, >region, etc). > >However, this column only contains 'jdoe', which is their first initial and >last name- which is how the email system is set up..(jgarcia, rstarr, etc!). > >All of these are '@xyz.com'. Is there some way to add the ' @xyz.com' to >what is already contained? I tried defining as special, but that hasn't >worked... > >Unless I'm doing it wrong?? > >thank you!
|
|
07-09-2008, 03:19 PM
|
|||
|
|||
|
Re: Help, please, adding on to items in a column...
Hi, Gord...
Thank you for the fast reply- I got it not long after posting... However, I'm embarrassed! I tried a few times, I'm simply not 'getting it'! I click on the column I want, F, and it's all highlighted... then??? thank you very much! Gord Dibben wrote: > =cellref & "@xyz.com" > > Copy down then select column and in place, copy>paste > special>values>ok>esc > > > Gord Dibben MS Excel MVP > > On Tue, 8 Jul 2008 15:47:21 -0400, "Uncle Vinnie" > <vinrin57@optonline.not.net> wrote: > >> Hi... >> >> I've tried, no luck, redefining contents of cells in one single >> column.... and would like to ask your help! >> >> Column F is a truncated listing of email addresses (A thru E, name, >> tel, region, etc). >> >> However, this column only contains 'jdoe', which is their first >> initial and last name- which is how the email system is set >> up..(jgarcia, rstarr, etc!). >> >> All of these are '@xyz.com'. Is there some way to add the ' >> @xyz.com' to what is already contained? I tried defining as >> special, but that hasn't worked... >> >> Unless I'm doing it wrong?? >> >> thank you! -- Thanks & B'rgds, Uncle Vinnie
|
|
07-09-2008, 07:34 PM
|
|||
|
|||
|
Re: Help, please, adding on to items in a column...
If column F contains the jdoe, rstarr etc. then enter the formula in G1 as
=F1 & "@xyz.com" Double-click on the fill handle of G1(small blck square at bottom right corner of G1) This will copy the formula down as far as you have data in column F G1 should be jdoe@xyz.com G2 should be rstarr@xyz.com Now select all of column G and copy>edit>paste special(in place)>values>ok>esc Gord On Wed, 9 Jul 2008 10:19:48 -0400, "Uncle Vinnie" <vinrin57@optonline.not.net> wrote: >Hi, Gord... > >Thank you for the fast reply- I got it not long after posting... > >However, I'm embarrassed! I tried a few times, I'm simply not 'getting it'! > >I click on the column I want, F, and it's all highlighted... then??? > >thank you very much! > >Gord Dibben wrote: >> =cellref & "@xyz.com" >> >> Copy down then select column and in place, copy>paste >> special>values>ok>esc >> >> >> Gord Dibben MS Excel MVP >> >> On Tue, 8 Jul 2008 15:47:21 -0400, "Uncle Vinnie" >> <vinrin57@optonline.not.net> wrote: >> >>> Hi... >>> >>> I've tried, no luck, redefining contents of cells in one single >>> column.... and would like to ask your help! >>> >>> Column F is a truncated listing of email addresses (A thru E, name, >>> tel, region, etc). >>> >>> However, this column only contains 'jdoe', which is their first >>> initial and last name- which is how the email system is set >>> up..(jgarcia, rstarr, etc!). >>> >>> All of these are '@xyz.com'. Is there some way to add the ' >>> @xyz.com' to what is already contained? I tried defining as >>> special, but that hasn't worked... >>> >>> Unless I'm doing it wrong?? >>> >>> thank you!
|
|
07-09-2008, 09:28 PM
|
|||
|
|||
|
Re: Help, please, adding on to items in a column...
Thank you, it worked!
Gord Dibben wrote: > If column F contains the jdoe, rstarr etc. then enter the formula > in G1 as > > =F1 & "@xyz.com" > > Double-click on the fill handle of G1(small blck square at bottom > right corner of G1) > > This will copy the formula down as far as you have data in column F > > G1 should be jdoe@xyz.com > > G2 should be rstarr@xyz.com > > Now select all of column G and copy>edit>paste special(in > place)>values>ok>esc > > > Gord > > On Wed, 9 Jul 2008 10:19:48 -0400, "Uncle Vinnie" > <vinrin57@optonline.not.net> wrote: > >> Hi, Gord... >> >> Thank you for the fast reply- I got it not long after posting... >> >> However, I'm embarrassed! I tried a few times, I'm simply not >> 'getting it'! >> >> I click on the column I want, F, and it's all highlighted... then??? >> >> thank you very much! >> >> Gord Dibben wrote: >>> =cellref & "@xyz.com" >>> >>> Copy down then select column and in place, copy>paste >>> special>values>ok>esc >>> >>> >>> Gord Dibben MS Excel MVP >>> >>> On Tue, 8 Jul 2008 15:47:21 -0400, "Uncle Vinnie" >>> <vinrin57@optonline.not.net> wrote: >>> >>>> Hi... >>>> >>>> I've tried, no luck, redefining contents of cells in one single >>>> column.... and would like to ask your help! >>>> >>>> Column F is a truncated listing of email addresses (A thru E, name, >>>> tel, region, etc). >>>> >>>> However, this column only contains 'jdoe', which is their first >>>> initial and last name- which is how the email system is set >>>> up..(jgarcia, rstarr, etc!). >>>> >>>> All of these are '@xyz.com'. Is there some way to add the ' >>>> @xyz.com' to what is already contained? I tried defining as >>>> special, but that hasn't worked... >>>> >>>> Unless I'm doing it wrong?? >>>> >>>> thank you! -- Thanks & B'rgds, Uncle Vinnie
|
|
07-10-2008, 04:02 AM
|
|||
|
|||
|
Re: Help, please, adding on to items in a column...
Good to hear.
Gord On Wed, 9 Jul 2008 16:28:33 -0400, "Uncle Vinnie" <vinrin57@optonline.not.net> wrote: >Thank you, it worked! > > > >Gord Dibben wrote: >> If column F contains the jdoe, rstarr etc. then enter the formula >> in G1 as >> >> =F1 & "@xyz.com" >> >> Double-click on the fill handle of G1(small blck square at bottom >> right corner of G1) >> >> This will copy the formula down as far as you have data in column F >> >> G1 should be jdoe@xyz.com >> >> G2 should be rstarr@xyz.com >> >> Now select all of column G and copy>edit>paste special(in >> place)>values>ok>esc >> >> >> Gord >> >> On Wed, 9 Jul 2008 10:19:48 -0400, "Uncle Vinnie" >> <vinrin57@optonline.not.net> wrote: >> >>> Hi, Gord... >>> >>> Thank you for the fast reply- I got it not long after posting... >>> >>> However, I'm embarrassed! I tried a few times, I'm simply not >>> 'getting it'! >>> >>> I click on the column I want, F, and it's all highlighted... then??? >>> >>> thank you very much! >>> >>> Gord Dibben wrote: >>>> =cellref & "@xyz.com" >>>> >>>> Copy down then select column and in place, copy>paste >>>> special>values>ok>esc >>>> >>>> >>>> Gord Dibben MS Excel MVP >>>> >>>> On Tue, 8 Jul 2008 15:47:21 -0400, "Uncle Vinnie" >>>> <vinrin57@optonline.not.net> wrote: >>>> >>>>> Hi... >>>>> >>>>> I've tried, no luck, redefining contents of cells in one single >>>>> column.... and would like to ask your help! >>>>> >>>>> Column F is a truncated listing of email addresses (A thru E, name, >>>>> tel, region, etc). >>>>> >>>>> However, this column only contains 'jdoe', which is their first >>>>> initial and last name- which is how the email system is set >>>>> up..(jgarcia, rstarr, etc!). >>>>> >>>>> All of these are '@xyz.com'. Is there some way to add the ' >>>>> @xyz.com' to what is already contained? I tried defining as >>>>> special, but that hasn't worked... >>>>> >>>>> Unless I'm doing it wrong?? >>>>> >>>>> thank you!
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
