youbet7469
New Member
- Joined
- Mar 20, 2002
- Messages
- 12
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
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