adding an e-mail address

[Dooma]

I have an excel list of many users with first name and last name in two
different cells. I wanted to create a third list that contains the last name
combined with my company e-mail address. is there a query I can do for the
whole list since I do not want individually?


Thanks in advance,

 

[Dave Peterson]

I'm not sure what you really want, but if the last name is in column B, then
maybe you can use a formula like:

=b1&"@yourcompanyname.com"

in C1 and then drag it down column C as far as you need.

 

[Bernie Deitrick]

Dooma,

Perhaps, something like

=B2 & "@YourCompany.com"

where B has the last names - then copy down, and convert the formulas to values.

HTH,
Bernie
MS Excel MVP