Originally posted by gutterz
yup. that is pretty simple. thank you for the explanation.
unfortunetly, the code isn't working.
any idea how i could modify...should it be working?
could the problem be that there are apt #'s that follow the text in some records? i should have mentioned that.
Yes, you're right. The function will only work if the characters on the end of your text are numbers. The function should work then as well but it will not work correctly.
It will convert for example "WallStreet135" into "WallStreet 135" but also "WallStreet135app25" into "WallStreet135app 25"
The function I gave you should work for most of the records. I'm afraid you'll have to do the others manually....
If you need changing the function, just open the module again and change anything you want.
After that, compile the code (command <Compile> in menu <Debug> in the VB window) and save your module again.