 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / General Excel Questions / March 2008Counting letters in a cell
My formula is =LEN(A1) and copied down. Is there a variation of this formula to count just the letters in each cell without counting the spaces between words ? Thanks for the reply.  SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. =LEN(SUBSTITUTE(A1," ","")) -- David Biddulph > My formula is =LEN(A1) and copied down. > Is there a variation of this formula to count just the letters in each > cell > without counting the spaces between words ? > Thanks for the reply. Thanks a lot David Biddulph. SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. > =LEN(SUBSTITUTE(A1," ","")) > -- [quoted text clipped - 5 lines] > > without counting the spaces between words ? > > Thanks for the reply. Do you happen to have a formula to count WORDS in a cell ? SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. > Thanks a lot David Biddulph. > [quoted text clipped - 7 lines] > > > without counting the spaces between words ? > > > Thanks for the reply. Depends how you want to define words, but if you want to count spaces and add one (unless the cell is empty), you could try: =IF(LEN(A1)=0,0,LEN(A1)-LEN(SUBSTITUTE(A1," ",""))+1) If you had multiple spaces in one place, that would get it confused, of course. -- David Biddulph > Do you happen to have a formula to count WORDS in a cell ? >> Thanks a lot David Biddulph. >> > =LEN(SUBSTITUTE(A1," ","")) >> > -- [quoted text clipped - 6 lines] >> > > without counting the spaces between words ? >> > > Thanks for the reply. Another one that will count the number of "words" separated by spaces: =LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1)," ",""))+(TRIM(A1)<>"") > Do you happen to have a formula to count WORDS in a cell ? > -- [quoted text clipped - 21 lines] > > > > I say : I don''''''''t even know, I don''''''''t > > > > know nothing. SignatureDave Peterson Thanks David. Thanks Dave. Both formulas work for me, appreciate your time. SignatureSocrates said: I only know, I don''''''''t know nothing. I say : I don''''''''t even know, I don''''''''t know nothing. > Another one that will count the number of "words" separated by spaces: > [quoted text clipped - 25 lines] > > > > > I say : I don''''''''t even know, I don''''''''t > > > > > know nothing. |
Reply to this Message |
 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
|
©2008 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.