Posted to microsoft.public.excel.programming

Robert Crandal[_2_] Robert Crandal[_2_] is offline

external usenet poster

Posts: 158

Count tokens in a string

My strings variables usually contain between 2 to 5
string tokens. Here are some examples:

myVar = "Todd Jones" ' 2 tokens
myVar = "Mary Jo Lynn Jackson" ' 4 tokens
myVar = "Peter James Smith Jr." ' 4 tokens

What is a good way to get the COUNT of the number
of tokens in my string?

Thanks

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
seeking template to track tokens played in arcade game and payout	arcademanager	Setting up and Configuration of Excel	3	June 23rd 08 11:29 AM
Count string IF.....	Coley	Excel Worksheet Functions	4	August 21st 07 05:52 AM
Count characters within a string	Francisco	Excel Worksheet Functions	4	April 10th 07 05:28 PM
count in a string	SHIRA	Excel Programming	5	April 26th 06 08:07 PM
Count Spaces In A String	Josh in Tampa	Excel Programming	2	October 23rd 03 05:59 PM

All times are GMT +1. The time now is 02:07 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us