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
ryloPlease 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