# Thread: Need Formula

1. ## Need Formula

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  Reply With Quote

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 :-)  Reply With Quote

#### Posting Permissions

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