making a username from data in two different columns

[Hughbie]

i have two columns.
one with first name
second with last name.

i want to make a third column to display first letter of first name and entire last name....

Tim Wilson twilson

any ideas?

Hugh

[Mordred]

Try adding the following to the 3rd column (note that I used columns A, B, & C):

=LEFT(A2,1)&B2

[Hughbie]

perfect...i knew it was a simple task....but couldn't figure it out....NOOB here.
thanks

[Mordred]

You're welcome. Please don't forget to mark your thread as solved.