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(...)

Hi
AFAIK left, mid, riht don't have probelms in VBA. So why do you want to
replace them?

--
Regards
Frank Kabel
Frankfurt, Germany

"
schrieb im Newsbeitrag
...
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(...)

Take a look at the descriptions at
http://www.mvps.org/dmcritchie/excel/join.htm#trimall
there may be an aspect you are missing such as copying
non breaking space characters from web pages.
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

" 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(...)

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(...)