+ Reply to Thread
Results 1 to 3 of 3

HOW TO EXTRACT STRINGS FROM CELLS

  1. #1
    vidhya
    Guest

    HOW TO EXTRACT STRINGS FROM CELLS

    hello
    i have an excell file with abt 100 records.
    one of the columns is of names. now i want that ´the first name and the
    last name should appear in different cells. what will b the formula to get
    the first n last names in two different columns depending on a blank space
    which separates them in the existing same coloumn of names
    thanking in advance

  2. #2
    Bob Phillips
    Guest

    Re: HOW TO EXTRACT STRINGS FROM CELLS

    =LEFT(A1,FIND(" ",A1)-1)
    and
    =RIGHT(A1,LEN(A1)-FIND(" ",A1))

    or else you could use Data>Text To columns with a space separator

    --

    HTH

    RP
    (remove nothere from the email address if mailing direct)


    "vidhya" <vidhya@discussions.microsoft.com> wrote in message
    news:26E0BBCE-5E0D-4AC5-A989-FC19448FDC15@microsoft.com...
    > hello
    > i have an excell file with abt 100 records.
    > one of the columns is of names. now i want that the first name and the
    > last name should appear in different cells. what will b the formula to get
    > the first n last names in two different columns depending on a blank space
    > which separates them in the existing same coloumn of names
    > thanking in advance




  3. #3
    Niek Otten
    Guest

    Re: HOW TO EXTRACT STRINGS FROM CELLS

    Menu:
    Data>Text to Columns

    --
    Kind regards,

    Niek Otten

    "vidhya" <vidhya@discussions.microsoft.com> wrote in message
    news:26E0BBCE-5E0D-4AC5-A989-FC19448FDC15@microsoft.com...
    > hello
    > i have an excell file with abt 100 records.
    > one of the columns is of names. now i want that the first name and the
    > last name should appear in different cells. what will b the formula to get
    > the first n last names in two different columns depending on a blank space
    > which separates them in the existing same coloumn of names
    > thanking in advance




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1