Thread: Trim in VBA
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach[_6_] Otto Moehrbach[_6_] is offline
external usenet poster
 
Posts: 201
Default Trim in VBA

Harald, Tom, & Gord
Thanks for your help. Otto
"Otto Moehrbach" wrote in message
...
Excel 2002, WinXP
The worksheet Trim function removes all trailing and leading spaces and

the
more-than-one spaces between words. The VBA Trim command does not address
the spaces between words.
Is there a variation of the Trim command that does address the excess
spaces between words or do I have to use the worksheet function in VBA to

do
that? Thanks for your help. Otto