Put this in cell C1 and then copy down.

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

<div>
Sorry, this way instead for last then first.<br />
<br />
<b>=LEFT(B1,7) &amp;&nbsp;LEFT(A1,1)</b>
</div>


Sorry, this way instead for last then first.

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

<div>
=lower(LEFT(B1,7) &amp;&nbsp;LEFT(A1,1) )
</div>


<div>
<div class="content wysiwyg-content">
Hello everyone<br />
<br />
I need help with an excel spreedsheet. &nbsp;lets say I have 3 columns A=First Name, B=Last Name, and C=UserID. &nbsp;I need to take first initail in column A and the first 7 characters in column B and combine them in C. &nbsp;So if I have a Terry Massengill the UserID would be massengt. &nbsp;The UserID would be formated lastname first initial. &nbsp;But only a total of 8 characters. &nbsp;Any help would be appreciated. &nbsp;
</div>
</div>


Hello everyone

I need help with an excel spreedsheet.  lets say I have 3 columns A=First Name, B=Last Name, and C=UserID.  I need to take first initail in column A and the first 7 characters in column B and combine them in C.  So if I have a Terry Massengill the UserID would be massengt.  The UserID would be formated lastname first initial.  But only a total of 8 characters.  Any help would be appreciated.  

Format first name and last name into userid in excel

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.