I am having difficulty debuging some code. I am wandering if I am simply
trying to nest to many If statements.

The code is as follows:

ActiveCell.FormulaR1C1 = _
"=IF(LEFT(RC[1],9)=""NASCO/REP"",""BLANK"",IF(LEFT(RC[1],5)=""HERTZ"",""HERTZ"",IF(LEFT(RC[1],5)=""DALLAS"",""DALLAS"",IF(LEFT(RC[1],5)=""ALFAX"",""ALFAX"",IF(LEFT(RC[1],5)=""OF/US"",""OFUSA"",IF(LEFT(RC[1],5)=""QUILL"",""QUILL"",IF(LEFT(RC[1],5)=""NASCO"",""NASCO"",IF(LEFT(RC[1],5)=""DOANE"",""TERA"",IF(LEFT(RC[1],3)=""NBF"",""NBF"",IF(LEFT(RC[1],3)=""IS-"",""IS"",""K"")))))))))))"

Do I need to find a way to do this w/o clumsy If's?

Josh

josh.eades atgmaildotcom