Yes, I figured you would do the rest yourself


--


Regards,


Peo Sjoblom


"Iguss" wrote in message
...
That goes something like this:

=IF(ISNUMBER(SEARCH("FARM",A2)),"FEDERAL
FARM",IF(ISNUMBER(SEARCH("HOME",A2)),"FEDERAL
HOME",IF(ISNUMBER(SEARCH("NATL",A2)),"FEDERAL NATL","")))

Thanks again

"Peo Sjoblom" wrote:

=IF(ISNUMBER(SEARCH("farm",A2)),etc


--


Regards,


Peo Sjoblom



"Iguss" wrote in message
...
I have the following


FEDERAL FARM CR this is what I need FEDERAL FARM CREDIT BANK
FEDERAL HOME BKS this is what I need FEDERAL HOME LOAN BANK
FEDERAL NATL MTG this is what I need FEDERAL NATIONAL MORTGAGE CORP

=IF(A2="*FARM*","FEDERAL FARM CREDIT BANK",IF(A2="*HOME*","FEDERAL HOME
LOAN
BANK",IF(A2,"*NATL*","FEDERAL NATIONAL MORTGAGE CORPORATION","")))

Can you please advise why a following formula doesn't work and how can
I
correct it.

Thank you