Excel help

  • Thread starter Thread starter hbsingh29
  • Start date Start date
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
(e-mail address removed)
 
Hi,

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

=A1 & "." & B1 & "@email.com"
 
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.
 
Thanks alot guys, saved me alot of time and i learnt a new function
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

if, and, Vlookup functions - mutiple matchng 2
Extract specific information from the body of outlook mail to an Excel File using VBA 0
Excell Formula 5
Text file to Excel 10
Merging Date Columns 7
Complex Formula to Find Doubles 7
autofilling a series of email addresses 7
First initials 3

Back
Top