Generating logins from first and last name fields

ckroon

Board Regular
Joined
Nov 9, 2005
Messages
60
Hey all TIA for the help.

Newb here, but I am a fast learner.

I have to generate hundreds of login names for users, the typical first initallastname configuration.
How can I do this with excel.. I have a worksheet with two columns, first name and last name.

How do I pluck the desired letters from the cells? First letter from cell one, then all of cell two, no spaces between them.

Thanks!
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
With the first name in Column A, last name in Column B, try this for your result cell (I used Column C):

=LEFT(A1)&B1

and copy down the column.

Hope that helps!
 

Watch MrExcel Video

Forum statistics

Threads
1,118,168
Messages
5,570,645
Members
412,335
Latest member
cinciri99
Top