I have been trying to write some code that will trim all spaces in between words of different length with no success, I can trim the spaces before and after, but no the spaces between words. Any one know some code to do this?
I have been trying to write some code that will trim all spaces in between words of different length with no success, I can trim the spaces before and after, but no the spaces between words. Any one know some code to do this?
Last edited by JapanDave; 02-09-2012 at 10:04 PM.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Maybe something like this (I took an example from another thread)
![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Ben Van Johnson
Hi
Another version
rylo![]()
Please Login or Register to view this content.
or
![]()
Please Login or Register to view this content.
@ nilem,
Thank you nilem, I shall use your Code as per Post#2
Thanks guys, I have now got it sorted!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks