Hi,

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

=A1 & "." & B1 & "



--
Hope that helps.

Vergel Adriano


" wrote:

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