Link to home
Create AccountLog in
Avatar of Montana Man
Montana ManFlag for United States of America

asked on

Excel Concatenation

In column A I have First Name and In column B I have Last Name, John Doe.  In Column C I would like to take the full name in column A and add the first letter of the lastname from column B, put that in the front and add the @domain.com to the end of it.  so the end result would be djohn@Domain.com

Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Assuming John is in A2 and Doe is in B2, then you may try this...

=LOWER(LEFT(B2,1)&A2&"@domain.com")

Open in new window

Which would return djohn@domain.com
ASKER CERTIFIED SOLUTION
Avatar of Bill Prew
Bill Prew

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account