Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / December 2005

Tip: Looking for answers? Try searching our database.

Letter Counting Function

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
bctrophy - 21 Dec 2005 21:36 GMT
I know Excel has a function for counting letter/characters in a cell,
but I don't want it to count spaces.  Any way to accomplish this?

And forgive me if topic exists somewhere on this forum.  I wanted to do
a search first, but clicking on "search" does nothing.

Thanks!

Robert

Signature

bctrophy

Ron Coderre - 21 Dec 2005 21:45 GMT
Try this...
For text in Cell A1
B1: =LEN(SUBSTITUTE(A1," ",""))

It replaces spaces with nothing, then counts the length.

Does that help?

Regards,
Ron

Signature

Ron Coderre

bctrophy - 21 Dec 2005 22:36 GMT
Ron,

That did it.  Works like a charm.  Much appreciated!!!!

Signature

bctrophy

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.