Home 
Search 
Today's Posts 
#1




Calculating number of letters in a string ...
Looking for a way to calculate the number of characters in a text string. I
can use the LEN function. e.g. If A1 contains "News Group", the number of characters is 9. Using the LEN(A1) formula would give me 10 (includes the space). How can I use this formula to omit the space? Thanks. Larry. 
#2




Try this:
=LEN(SUBSTITUTE(A1," ",""))  HTH, RD  Please keep all correspondence within the NewsGroup, so all may benefit !  "Larry Wallis" wrote in message ... Looking for a way to calculate the number of characters in a text string. I can use the LEN function. e.g. If A1 contains "News Group", the number of characters is 9. Using the LEN(A1) formula would give me 10 (includes the space). How can I use this formula to omit the space? Thanks. Larry. 
#3




suppose the Word "News Group" is in cell A1 use the following formula in B1:
=LEN(SUBSTITUTE(A1," ","")) This will first substitute all spaces in the string with nothing and then return the length of the new string giving you the desired length.... Hope this Helps Ο "Larry Wallis" έγραψε στο μήνυμα ... Looking for a way to calculate the number of characters in a text string. I can use the LEN function. e.g. If A1 contains "News Group", the number of characters is 9. Using the LEN(A1) formula would give me 10 (includes the space). How can I use this formula to omit the space? Thanks. Larry. 
#4




Thanx RD.
Larry. "Ragdyer" wrote in message ... Try this: =LEN(SUBSTITUTE(A1," ",""))  HTH, RD   Please keep all correspondence within the NewsGroup, so all may benefit !   "Larry Wallis" wrote in message ... Looking for a way to calculate the number of characters in a text string. I can use the LEN function. e.g. If A1 contains "News Group", the number of characters is 9. Using the LEN(A1) formula would give me 10 (includes the space). How can I use this formula to omit the space? Thanks. Larry. 
#5




And thanx to u too Geovas.
Larry. "Geovas" wrote in message ... suppose the Word "News Group" is in cell A1 use the following formula in B1: =LEN(SUBSTITUTE(A1," ","")) This will first substitute all spaces in the string with nothing and then return the length of the new string giving you the desired length.... Hope this Helps Ο "Larry Wallis" έγραψε στο μήνυμα ... Looking for a way to calculate the number of characters in a text string. I can use the LEN function. e.g. If A1 contains "News Group", the number of characters is 9. Using the LEN(A1) formula would give me 10 (includes the space). How can I use this formula to omit the space? Thanks. Larry. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Calculating number of letters in a string ...  Excel Discussion (Misc queries)  
How can I assign a number to a string?  Excel Discussion (Misc queries)  
Read Text File into Excel Using VBA  Excel Discussion (Misc queries)  
count number of occurences within a string  Excel Worksheet Functions  
GET.CELL  Excel Worksheet Functions 