|Excel and Office
Stripping spaces and vowels from strings in Access
Q: I heard something interesting at the conference I attended last week that will help me in my daily work but I can't figure out how to do it. In Access, how would one go about removing spaces and vowels from a text string?
A: Get ready for this, because it ain't pretty...
That'll do it, but a custom function in VBA would probably be neater.
Postscript: Greg Chapman (http://www.layer1wireless.com) proved me right on this last point, with this follow-up:
You're right, that's ugly but it's very functional. I like it!
Here's the VBA version (no prettier, I'm afraid) with a subroutine made to test the function: