Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2004
    Location
    Rochester, New Hampshire, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Dealing with Names (2000)

    I would like Excel to look at two columns and take a persons first name (say A2) and Last Name (say B2) and put in column C3 there initials. Example Chris (A2) Benson (B2) column C2 should equal CB. Help??

  2. #2
    Platinum Lounger
    Join Date
    Nov 2001
    Location
    Vienna, Wien, Austria
    Posts
    5,009
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dealing with Names (2000)

    Try =CONCATENATE(Left(A2,1),Left(B2,1))

    HTH
    Gre

  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    Birmingham, England
    Posts
    123
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dealing with Names (2000)

    And if you wanted a space between the initials,
    =(Left(A2,1)&" "&Left(B2,1))

  4. #4
    Lounger
    Join Date
    Jan 2004
    Location
    Rochester, New Hampshire, USA
    Posts
    27
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Dealing with Names (2000)

    Thank YOU Thank YOU, You do not know how much simpler you just made my life!!!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •