Urgently need help with creating formulas

  • Thread starter Thread starter Kat Hughes
  • Start date Start date
K

Kat Hughes

Hello

My worksheet is full of thousands of firstnames, middle names
surnames, email addresses etc etc. How do I create a formula that wil
result in having each persons *first name, initial of middle name
surname and email address * ?

I would really appreciate some help.

Thank you.

Ka
 
Kat

Your urgency is going to increase.

You have left out a few important details.

Like.........how is the data currently laid out?

Single cells? Rows? Columns? Randomly inserted all over the map?

What does "etc etc" mean?

Post back with some info when you have stopped hyper-ventilating.

Gord Dibben Excel MVP
 
Kat,

If all the data is in columns you could use concatenate.

=concatenate(A1," ",B1," ",C1," ",D1)
 
Hello Kat

Assume that columns are as follows
A has First
B has Middle
C has Surname
D has EMail
and E is where you want combined info

Also assume that data starts in row 2

Enter the following into E2:
=A2 & " " & LEFT(B2,1) & " " & C2 & " " & D2

You can then copy this down as necessary

Alan
 
Back
Top