Merging Columns - First Name Initial & Full Last Name

  • Thread starter Thread starter bittersweet
  • Start date Start date
B

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...
 
bittersweet said:
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...
Click to expand...

=LOWER(LEFT(A1,1)&B1)
Regards.
 
Back
Top