Apparently you ignored the suggestions that might have actually solved the
problem.

Maybe you need to go back and take a look.

Using Worksheetfunction.Trim and prefacing the commands with VBA are
bandaids.

--
Regards,
Tom Ogilvy

" wrote in
message ...
I had previously asked a question regarding Trim(.... not working
correctly
in Excel 97. While the Trim statement works without any problems in Office
2003 it does not work in Excel 97. The solution at that time was:

WorksheetFunction.Trim(...)

That worked for Trim(...)
but does not work for Left(...)

I get an invalid method error.

Is there another solution for Left(...)
and for Mid(...)