Excel: Count number of spaces in a cell

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

Comments

Post a Comment

Popular posts from this blog

Künefe Tarifi

Image
Turkish Kunefe (Künefe) Künefe is considered to be one of the most delicious Turkish desserts, especially in the city of Antakya (Antioch) located on Mediterrenean Sea, in Southern Turkey. Although künefe shops are very common throughout Hatay, Kilis, Adana, Mersin and Gaziantep provinces, the city of Antakya in Hatay is known for the best künefe in Turkey. What distinguishes Antakya’s künefe from others is the daily made fresh, elastic cheese that is only made in Hatay region. The kadayıf (shredded phyllo dough) is also made from scratch at small künefe shops in almost every corner in Antakya which I find very entertaining to watch. The künefe shops in Antakya serve the künefe topped with cream or ice cream. Every time I visit home, I go to Antakya which is about two hours from my hometown and have künefe with ice cream. One of my favorite p...
Read more

Bir Word Belgesinde Kapak Harici Kaç sayfa Olduğunu Bulmak

To count the number of pages in a MS Word document without the front page you do the following Press Ctrl+F9 . Word inserts an empty set of field code braces Type an equal sign and a space Press Ctrl+F9 again. Word inserts another empty set of field code braces Type NUMPAGES and a space. Position the insertion point just between the final two right braces. Type a minus sign and a 1. Your field code for the Y page number should now look very similar to this:  { = { NUMPAGES } – 1 } Press Shift+F9 to collapse the fields. The "1" may be exchanged for any other number if you want. SECTIONPAGES may be used to get the number of pages in a section of a document.
Read more