Merging Columns - First Name Initial & Full Last Name

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...
 
B

BenjieLop

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

list items from one table in another table based on value in first table 2
Seperate first and last name within a cell 3
Excel Newb: Splitting First name and Last name 1
moving first word in a column to a separate column 8
Help, please, adding on to items in a column... 5
Comapre columns 4
Using lookup formula using more than one cell 5
complicated text to column 4

Top