in a separate are in the sheet make 2 columns
in the first column say Col A type your searched values like
"CHANGE","NCR","Plus/Minus"
In the column next to COL B it type their replacement values " CHANGE
ORDER", NCR etc

=INDEX($B$1:$B$4,MATCH(TRUE,ISNUMBER(SEARCH("*"&J1 1&"*","*"&A1:A4&"*")),0))&IF(B11="","","")
array entered (ctrl+shift+enter)

This way there is no restriction of 7





"Dolores" wrote in message
...
I am working with excel (office 2003) mainly based on "text-cells". I have
created a formula where I can nestl up to 7 funktions but not more! Goal
is
to sort out of a certain text, in a cell, a certain word that has to be
shown
at the end.
eg:
=IF(ISNUMBER(FIND("CHANGE",J11)),"CHANGE
ORDER",(IF(ISNUMBER(FIND("NOTICE",J11)),"NOTICE",( IF(ISNUMBER(FIND("NCR",J11)),"NCR",(IF(ISNUMBER(FI ND("Plus/Minus",J11)),"PLUS/MINUS",(IF(ISNUMBER(FIND("Minutes",J11)),"MOM",(IF (ISNUMBER(FIND("RFI",J11)),"RFI")))))))))))&IF(B11 ="","","")