Urgently need help with creating formulas

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
 
G

Gord Dibben

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
 
A

Andrew Hargreaves

Kat,

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

=concatenate(A1," ",B1," ",C1," ",D1)
 
A

Alan

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
 
Top