Results 1 to 2 of 2

Thread: Need Formula

  1. #1

    Need Formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi

    I need formula for the following requirement:
    1. In Column A, I have name of the Funds. I need the formula which can
    take only the first name of the fund and put it in Col B.
    Eg. If in Column A it is Templeton India Growth, then in col B it shd take only Templeton.
    Can this be done, if yes pls provide me the formula.

    Rgds
    SVK
    Rgds
    SVK

  2. #2
    Hi SVK...

    you can use the Left() function and, assuming the first name is always the word
    before the first space, you have, IMHO the simplest method...

    A1 = Templeton India Growth
    B1 = LEFT(A1;FIND(" ";A1)-1)

    In case you would like to verify, if a space is really included in the text, then you
    can use a little bit more complexier formula...

    A1 = Templeton India Growth
    B1 = IF(ISERROR(FIND(" ";A1));A1;LEFT(A1;FIND(" ";A1)-1))

    Regards :-)

Posting Permissions

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