Join Initial & Surname In Excel 2k

[Mictain]

Hi All,

I know there is a way to split 'same cell' forename and surname data and place either one in a separate cell, but how do you make a combination of the two from separate cells?

For instance, A column = surname, B column = first name.

So A1 = Bloggs, B1 = Fred

I'm looking to make a typical initial & surname e-mail address from this, utilising a standard domain name, leaving me with;

fbloggs@blahblah.com

Does anyone know how to at least achieve the 'name merge' part of this, please? I have quite a few names to run through!

Many thanks.

Neil.

 

[bluedragon2]

=LEFT(B1,1)&A1

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Bowers74]

Something like this will work for you!

=LEFT(B1,1)&A1&"@blahblah.com"

;-)



Peace!!

Mike

Didn't get the answers that you wanted? Take a look at FAQ219-2884

 

[Molby]

Try

=B1& " " &A1 if you want a space or
=B1&A1 without a space

 

[bluedragon2]

If you want them all lower case, then:

=LOWER(LEFT(B1,1)&A1)

If you want to add the @blahblah.com then:

=LOWER(LEFT(B1,1)&A1&"@blahblah.com")



[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...

 

[Mictain]

Wow! I turn away for thirty seconds, hear some scuffling noises, turn back, and I have four replies

Thank you all very much indeed. I may now get home at a reasonable hour

Neil.