Assuming your data is in columns a, b and c, the following will create the
Username for you:

=lower(left(a3,1)&b3)

--
Regards,
Fred


"kevin_jones01" wrote in message
...
I am trying to copy the first character of a cell and combine it with another
row and place it in another row. I am trying to create usernames from two
columns First Name and Last Name. I am trying to use Concatenation is this
possible. How do I do this?

Example:

First Name Last Name Username

Jim Bob jbob
Sally Richards srichards