Thanks alot now it makes sense.

As it turned out, the excel file DID have spaces all over the place so the formula would NOT have worked with all the trim functions. (unless we had stripped them out of the excel file beforehand. (i think))