counting charcters and digits but ignoring spaces and punctu

[youbet7469]

I am attempting to count the number of characters and digits in a cell, but at the same time ignore punctuation marks and spaces.

Example:
1) See Pug run.
charcter count would= 9
2) Todays date is 04/17/2002.
character count would =20

I've read the posts about "counting problem" and "counting digits", but haven't been able to figure out how to modify those formulas to fit what I am looking for them to do. Can anyone give me any help?

Thank You!
Greg

 

[Yogi Anand]

Yogi, unfortunately Excel's CODE worksheet function only supports Windows' ANSI character set. So even though you can enter (paste) the Greek letter Delta (Ä), the CODE worksheet function will "see" it as ASCII 63 (?).

Thanks Mark!