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

=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" <(E-Mail Removed)>
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!

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"
> <(E-Mail Removed)> 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

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 (E-Mail Removed)

G2 should be (E-Mail Removed)

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" <(E-Mail Removed)>
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"
>> <(E-Mail Removed)> 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!

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 (E-Mail Removed)
>
> G2 should be (E-Mail Removed)
>
> 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"
> <(E-Mail Removed)> 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"
>>> <(E-Mail Removed)> 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

Good to hear.

Gord

On Wed, 9 Jul 2008 16:28:33 -0400, "Uncle Vinnie" <(E-Mail Removed)>
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 (E-Mail Removed)
>>
>> G2 should be (E-Mail Removed)
>>
>> 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"
>> <(E-Mail Removed)> 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"
>>>> <(E-Mail Removed)> 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!