Merging Columns - First Name Initial & Full Last Name

[bittersweet]

I need to assign usernames to thousands of users in a spreadsheet. I have first name and last name in seperate columns. I'd like the username to be an initial for the first name and the full last name and have the username be completely in lowercase (see below).

Column A (first name) = John
Column B (last name) = Doe
Column C (username) = jdoe

Is there a formula that could be written that would allow me to do the above? I haven't been able to find anything in the Excel help files or on the Web.

Appreciate any assistance...

[BenjieLop]

I need to assign usernames to thousands of users in a spreadsheet. I have first name and last name in seperate columns. I'd like the username to be an initial for the first name and the full last name and have the username be completely in lowercase (see below).

Column A (first name) = John
Column B (last name) = Doe
Column C (username) = jdoe

Is there a formula that could be written that would allow me to do the above? I haven't been able to find anything in the Excel help files or on the Web.

Appreciate any assistance...

=lower(left(A1,1)&B1)
Regards.

[[email protected]]

The following formula should do it.

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

[bittersweet]

That did the trick! Thanks so much for your help.