I have 3 columns, I need to take the first letter of column 2 and the remaining letters of column 1 to create column 3's user id.

Column A - LastName
Column B - FirstName
Column C - UserID (Currently Blank)

Example:

ColumnA Column B Column C (Result Column)
--------- --------- ---------
Anderson Heidi HAnderson