=lower(left(A2, 1) & B2)

"Paul" wrote in message
...
Hello,

I have 2 columns first name and last name...trying to merge both colums to
have first letter of first name and last name:

A B
John Doe
Dallas Smith

I want to have jdoe and dsmith. Please help!

Paul