Enter

= B1 & "_" & A1 & "

in Cell C1 and copy that from C2 to C500

Alok Joshi


"Biochemist" wrote:

I have a excel spread sheet with cell a1 - a500 that has last name and cell
b1 -b500 that has first name and I know the e-mail address for all 500
people, what I need to be able to do is creat a row that will have the same
e-mail address after there last name, with an underscore between first and
last name, it would look something like . I have had
some one explaine how to get ther name and email address into a new cell, how
ever what I dont know how to do now is put the underscore between first and
last name