ms access: how count # words in a string

A

arvintheoc

Table A has phrases:
I run
I catch thief and claim reward
He wants ice cream

How do I count # words in each row? for this case:
2
6
4
Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
How to count the numbers in a Word document? 0
Integrating information from Word to Excel (not mail merge) 1
Autonumber field in Excel that behaves the same as Access 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
How do I create a set of words that are flagged? 0
Word VBA - Delete text from bulleted paragraphs 1
ms access: query to compare strings in tables & count 6

Top