Question with Microsoft XL (.xls)

Discussion in 'OT Technology' started by GotVtec, Jul 28, 2003.

  1. GotVtec

    GotVtec 8th World Wonder

    Joined:
    Mar 14, 2000
    Messages:
    575
    Likes Received:
    0
    Location:
    Omaha, NE
    Okay, say you have about 1500 entries in a certain field named "NAME" and they are all entered in as "Mr. Billy A. Johnson" or whatever. Is there a way I can strip that down to just the Billy or the first name in each of the entries for that field?
     
  2. 5Gen_Prelude

    5Gen_Prelude There might not be an "I" in the word "Team", but

    Joined:
    Mar 14, 2000
    Messages:
    14,519
    Likes Received:
    1
    Location:
    Vancouver, BC, CANADA
    =LEFT(A1,SEARCH(" ",A1)-1)

    put the formula wherever you want and put a name in a1
     

Share This Page