98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Access VBA Training and help » Remove punctuation
Remove punctuation
Resolved · Urgent Priority · Version 2003
Tue 7 Oct 2008, 16:24Delegate Gillian said...
Gillian has attended:
Access VBA course
Excel Advanced course
Remove punctuation
Hello,
Is there a way to remove all punctuation characters from a string in a table field? The 'replace' function only removes one substring character at a time, whereas I'd like to remove all ANSI characters 33 to 47 in one go.
Thankyou
Thu 9 Oct 2008, 13:21Trainer Amanda said...
RE: remove punctuation
Hello Gillian
Thank you for your post.
This is something that we would advise on in a consulting capacity, for which there would be an associated cost.
If you would like to receive a quotation from our enquiries team for consultancy work, please contact info@stl-training.co.uk or phone phone number.
Thank you
Best Training team
Wed 18 Jan 2017, 11:06FormulaV (guest) said...
RE: remove punctuation
I suppose, punctuation skills have to be improved during all life long! http://essay-editor.net/blog/useful-tips-how-to-improve-your-punctuation-skills will help you to do this!
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:Remove spaces in a tableIf you have a table that has too many space marks littered around, you can create a update query and use the trim function to get rid of any excess space marks |
