Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Feb 2005
    Posts
    207
    Thanks
    0
    Thanked 0 Times in 0 Posts
    I have don Adams in cell A3. I need a formula in cell B3 that will look in cell A3 and show me only Don. I need a formula in cell C3 that will look in cell A3 and show me only Adams.

    Thanks in advance.

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    In B3
    =LEFT(A3,FIND(" ",A3)-1)

    In C3:
    =RIGHT(A3,LEN(A3)-FIND(" ",A3))

    This presumes you will always have things of the form:
    First name then 1 space then the last name...

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Aug 2004
    Posts
    123
    Thanks
    0
    Thanked 1 Time in 1 Post
    [quote name='TheDon' post='788127' date='09-Aug-2009 03:57']I have don Adams in cell A3. I need a formula in cell B3 show me Don. and cell C3 show me Adams.[/quote]

    Another option :

    B3 =MID(A3,1,FIND(" ",A3)-1)

    C3 =MID(A3,FIND(" ",A3)+1,99)

    Or

    B3 =REPLACE(A3,FIND(" ",A3),99,"")

    C3 =REPLACE(A3,1,FIND(" ",A3),"")

    Regards
    Bosco

Posting Permissions

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