Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

remove punctuation

ResolvedVersion 2003

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

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

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 courses

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
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Access tip:

Creating Parameter wildcard queries

To creat a parameter query that also uses a wildcard, in the query design type in like []+*.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.19 secs.