Excel 97 Left(.....

[Guest]

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

 

[Frank Kabel]

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

--
Regards
Frank Kabel
Frankfurt, Germany

"(e-mail address removed)" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...

 

[David McRitchie]

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.

 

[Tom Ogilvy]

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.