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.