Excel help

H

hbsingh29

Hi there,

I'am a fairly new novice to the world of excel and have a few
questions to ask.

the first one being, how can i convert first names and surnames into e-
mail addressess without out doing it one by one. i.e
[email protected]
 
V

Vergel Adriano

Hi,

With the first name in A1 and last name in B1, in C1 enter the formula:

=A1 & "." & B1 & "@email.com"
 
D

David Biddulph

If you've got first names in column A, surnames in column B, and domain
names in column C, then in cell D2 you can put the formula =A2&"."&B2&"@"&C2
Then copy the formula as far down the column as you need.
 
Top