Share via

Function To Create Usernames Firstname_First Initial Of Last Name

Anonymous
2015-11-30T20:05:56+00:00

I have am trying to take a First Name (A1), insert a _, First letter of last name (B2).  I have this working

=left(a1,1) & "." & b1 which takes John Smith and creates J_Smith but I need the opposite.

I am trying to get John_S

I tried this but it didn't work:

=left a1, & "." & (b1,1) but this gives me an error

What am I doing wrong?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2015-11-30T20:14:12+00:00

=a1&"_"&left(b1,1)

Jim

Was this answer helpful?

0 comments

Answer accepted by question author

HansV 462.6K Reputation points
2015-11-30T20:13:57+00:00

Use this instead:

=A1&"_"&LEFT(B1)

Was this answer helpful?

0 comments

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2015-11-30T23:19:28+00:00

    Thank you everyone! That did the trick.

    Was this answer helpful?

    0 comments
  2. Vijay A. Verma 104.9K Reputation points Volunteer Moderator
    2015-11-30T20:14:39+00:00

    Use below function -

    =A1&"."&LEFT(B1,1)

    (Please see whether you want a "_" in place of "."

    Was this answer helpful?

    0 comments