character count

**ajshap1** · 11-09-2006, 05:36 PM

Is there a character count in Excel for alpha number titles or sentences?

Thanks

**duane** · 11-09-2006, 05:40 PM

with a string of text in cell a1. this will count the non blanks

=LEN(SUBSTITUTE(A1," ",""))

**oldchippy** · 11-09-2006, 07:08 PM

Originally Posted by ajshap1

Is there a character count in Excel for alpha number titles or sentences?

Thanks

Hi ajshap1,

With this in A1, Is there a character count in Excel for alpha number titles or sentences? and in A2

=LEN(A1), this will count all characters including spaces and punctuation

character count

LinkBack

Thread Tools

Rate This Thread

Display

character count

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions