{"id":33689,"date":"2023-12-25T04:29:55","date_gmt":"2023-12-25T03:29:55","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=33689"},"modified":"2024-03-22T15:49:16","modified_gmt":"2024-03-22T14:49:16","slug":"count-characters-in-excel","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-characters-in-excel\/","title":{"rendered":"How to Count Characters in Excel &#8211; 3 Easy Formulas"},"content":{"rendered":"<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-33773 size-large\" title=\"Count Characters in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1024x576.png\" alt=\"Count Characters in Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1024x576.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-300x169.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-768x432.png 768w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel.png 1280w\" sizes=\"(max-width: 1024px) 100vw, 1024px\" \/><\/a><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/free-excel-online-training-courses\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a> provides several<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong> built-in functions<\/strong><\/a> that make it easy to <strong>count characters for different purposes<\/strong>. It can be used to<strong> determine the number of individual characters (letters, numbers, symbols, and spaces) within a cell, a range of cells, or specific characters within the text<\/strong> in Excel. In this article, we will cover the following topics in detail &#8211;<\/p>\n<p>Let us look at each of these methods.<\/p>\n<p>Download the Excel Workbook below to follow along and understand How to Count Characters in Excel \u2013<br \/>\n<a class=\"IRPP_minimalist icon-download\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel.xlsx\" target=\"_blank\" rel=\"noopener\"><span class=\"ctaText px-3 text-capitalize\"><strong>download excel\u00a0<\/strong><strong>workbook<\/strong><\/span><span class=\"postTitle px-3\">Count-Characters-in-Excel.xlsx<\/span><\/a><\/p>\n<p>&nbsp;<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_57_1 counter-flat ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title \" >Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li><a href=\"#\" class=\"scroll-to-download\">Free Practice Workbook<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-characters-in-excel\/#Count_Characters_in_Cell\" title=\"Count Characters in Cell\">Count Characters in Cell<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-characters-in-excel\/#Count_Characters_in_Range_of_Cells\" title=\"Count Characters in Range of Cells\">Count Characters in Range of Cells<\/a><\/li><li class='ez-toc-page-1'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-characters-in-excel\/#Count_Specific_Characters\" title=\"Count Specific Characters\">Count Specific Characters<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Count_Characters_in_Cell\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Count Characters in Cell<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>The <\/strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/getting-the-length-of-text-with-excels-len-formula\/\" target=\"_blank\" rel=\"noopener\"><strong>LEN<\/strong><\/a> function is a straightforward and user-friendly formula in Excel. It gives you the <strong>count of the total number of characters<\/strong> in a single cell. It <strong>includes<\/strong> all characters in the cell, whether they are <strong>spaces, punctuation marks, <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/special-characters-in-excel\/\" target=\"_blank\" rel=\"noopener\">special characters<\/a>, numbers<\/strong>, and more.\u00a0The <strong>syntax<\/strong> of this function is &#8211;<\/p>\n<p><strong>=LEN(text)<\/strong><\/p>\n<p>where,<\/p>\n<p><strong>Text<\/strong> &#8211; The text whose length you want to find.<\/p>\n<p>In the following example, let&#8217;s determine the number of characters in cell A2. To get the result, enter the LEN formula followed by the reference to cell A2 enclosed in parentheses.<\/p>\n<p><strong>=LEN(A2)<\/strong><\/p>\n<p>Once you execute the formula, Excel will display the total number of characters present in cell A2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-2.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33697\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-2.png\" alt=\"Count Characters in Excel\" width=\"814\" height=\"285\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-2.png 814w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-2-300x105.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-2-768x269.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" title=\"\"><\/a><\/p>\n<p>In the example below, you will see that there are <strong>additional spaces within the text<\/strong>. What if you want to<strong> remove those unwanted spaces<\/strong> and then get the count of characters?<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-3.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33698\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-3.png\" alt=\"\" width=\"814\" height=\"283\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-3.png 814w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-3-300x104.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-3-768x267.png 768w\" sizes=\"(max-width: 814px) 100vw, 814px\" title=\"\"><\/a><\/p>\n<p>You can seamlessly achieve this by combining the LEN function with <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/cleaning-data-with-the-trim-formula-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>TRIM<\/strong><\/a>. The modified formula would look like this &#8211;<\/p>\n<p><strong>=LEN(TRIM(A2)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33696\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1.png\" alt=\"\" width=\"818\" height=\"312\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1.png 818w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1-300x114.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-1-768x293.png 768w\" sizes=\"(max-width: 818px) 100vw, 818px\" title=\"\"><\/a><\/p>\n<p>By incorporating TRIM into the equation, unwanted spaces are first removed, and subsequently, the <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/replicating-excels-len-function-with-m-in-power-query\/\" target=\"_blank\" rel=\"noopener\">LEN function<\/a> provides you with an accurate count of characters, excluding any unwanted spaces.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Count_Characters_in_Range_of_Cells\"><\/span><strong><span id=\"1\" style=\"color: #ff0000;\">Count Characters in Range of Cells<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>When you need to analyze multiple cells at once, you can use the SUMPRODUCT and LEN functions together. LEN will provide you with the count of characters in each cell and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/sumproduct-in-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>SUMPRODUCT<\/strong><\/a> will provide you with the summation of those values.<\/p>\n<p>In this example, our goal is to determine the cumulative number of characters in the range A2:A6. Follow the steps outlined below to obtain the desired result &#8211;<\/p>\n<p><strong>STEP 1: Enter the <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/advanced-sumproduct-function-count\/\" target=\"_blank\" rel=\"noopener\">SUMPRODUCT function<\/a><\/strong>.<\/strong><\/p>\n<p><strong>=SUMPRODUCT(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-33699 size-full\" title=\"Count Characters in Excel\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-4.png\" alt=\"Count Characters in Excel\" width=\"1010\" height=\"308\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-4.png 1010w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-4-300x91.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-4-768x234.png 768w\" sizes=\"(max-width: 1010px) 100vw, 1010px\" \/><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Enter the <strong>LEN<\/strong> function.<\/p>\n<p><strong>=SUMPRODUCT(LEN(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-5.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33700\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-5.png\" alt=\"\" width=\"937\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-5.png 937w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-5-300x96.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-5-768x246.png 768w\" sizes=\"(max-width: 937px) 100vw, 937px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span>Select the range of cells<\/strong> containing the text whose length you want to find.<\/p>\n<p><strong>=SUMPRODUCT(LEN(A2:A6))<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-6.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33701\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-6.png\" alt=\"\" width=\"926\" height=\"312\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-6.png 926w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-6-300x101.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-6-768x259.png 768w\" sizes=\"(max-width: 926px) 100vw, 926px\" title=\"\"><\/a><\/p>\n<p>Once you execute the formula, Excel will <strong>display the total number of characters in the cell range A2:A6<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-17.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33712\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-17.png\" alt=\"Count Characters in Excel\" width=\"848\" height=\"282\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-17.png 848w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-17-300x100.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-17-768x255.png 768w\" sizes=\"(max-width: 848px) 100vw, 848px\" title=\"\"><\/a><\/p>\n<p>If you manually count the characters in each cell and then sum up these individual counts, the result would be the same as the one provided by the SUMPRODUCT-LEN combination.<\/p>\n<p>&nbsp;<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Count_Specific_Characters\"><\/span><strong><span id=\"3\" style=\"color: #ff0000;\">Count Specific Characters<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Counting occurrences of a specific character within a cell can be accomplished using a combination of the LEN and <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/category\/formulas\/text\/substitute\/\" target=\"_blank\" rel=\"noopener\"><strong>SUBSTITUTE<\/strong><\/a> functions. The <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/count-text-occurrences-excels-substitute-formula\/\" target=\"_blank\" rel=\"noopener\">SUBSTITUTE formula in Excel<\/a> can help you replace one specific text with another easily.<\/p>\n<p>You can use this function to replace the instances of a specified character (that you want to count) with an empty string, allowing you to calculate the difference in length before and after substitution.<\/p>\n<p><strong>=LEN(text)-LEN(SUBSTITUTE(text,old_text,new_text)<\/strong><\/p>\n<p>In this example, you need to count the occurrence of the letter &#8220;a&#8221; in the text mentioned in cell A2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-18.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33713\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-18.png\" alt=\"Count Characters in Excel\" width=\"740\" height=\"198\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-18.png 740w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-18-300x80.png 300w\" sizes=\"(max-width: 740px) 100vw, 740px\" title=\"\"><\/a><\/p>\n<p>Follow the steps below to achieve the result &#8211;<\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 1: <\/span><\/strong>Enter the <b>LEN <\/b>function.<\/p>\n<p><strong>=LEN(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-8.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33703\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-8.png\" alt=\"\" width=\"821\" height=\"290\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-8.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-8-300x106.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-8-768x271.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 2: <\/span><\/strong>Select the cell containing the text.<\/p>\n<p><strong>=LEN(A2)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-9.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33704\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-9.png\" alt=\"\" width=\"821\" height=\"283\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-9.png 821w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-9-300x103.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-9-768x265.png 768w\" sizes=\"(max-width: 821px) 100vw, 821px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 3: <\/span><\/strong>Enter the <b>minus (-) <\/b>sign.<\/p>\n<p><strong>=LEN(A2)-<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-10.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33705\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-10.png\" alt=\"\" width=\"816\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-10.png 816w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-10-300x106.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-10-768x270.png 768w\" sizes=\"(max-width: 816px) 100vw, 816px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 4: <\/span><\/strong>Enter the <b>LEN <\/b>function.<\/p>\n<p><strong>=LEN(A2)-LEN(<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-11.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33706\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-11.png\" alt=\"\" width=\"806\" height=\"286\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-11.png 806w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-11-300x106.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-11-768x273.png 768w\" sizes=\"(max-width: 806px) 100vw, 806px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 5: <\/span><\/strong>Enter the <b>SUBSTITUTE <\/b>function.<\/p>\n<p><strong>=LEN(A2)-LEN(<b>SUBSTITUTE(<\/b><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-12.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33707\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-12.png\" alt=\"\" width=\"939\" height=\"285\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-12.png 939w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-12-300x91.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-12-768x233.png 768w\" sizes=\"(max-width: 939px) 100vw, 939px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 6: <\/span><\/strong>Select the cell containing the text.<\/p>\n<p><strong>=LEN(A2)-LEN(<b>SUBSTITUTE(A2<\/b><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-13.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33708\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-13.png\" alt=\"\" width=\"967\" height=\"281\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-13.png 967w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-13-300x87.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-13-768x223.png 768w\" sizes=\"(max-width: 967px) 100vw, 967px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 7: <\/span><\/strong>Type the character that you want to count within quotes.<\/p>\n<p><strong>=LEN(A2)-LEN(<b>SUBSTITUTE(A2,&#8221;a&#8221;<\/b><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-14.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33709\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-14.png\" alt=\"\" width=\"930\" height=\"288\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-14.png 930w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-14-300x93.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-14-768x238.png 768w\" sizes=\"(max-width: 930px) 100vw, 930px\" title=\"\"><\/a><\/p>\n<p><strong><span style=\"color: #ff0000;\">STEP 8: <\/span><\/strong>Type an empty string.<\/p>\n<p><strong>=LEN(A2)-LEN(<b>SUBSTITUTE(A2,&#8221;a&#8221;,&#8221;&#8221;)<\/b><\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-15.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33710\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-15.png\" alt=\"\" width=\"895\" height=\"287\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-15.png 895w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-15-300x96.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-15-768x246.png 768w\" sizes=\"(max-width: 895px) 100vw, 895px\" title=\"\"><\/a><\/p>\n<p>Excel will provide you with the count of the letter &#8220;a&#8221; in the text mentioned in cell A2.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-16-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-33714\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-16-1.png\" alt=\"Count Characters in Excel\" width=\"817\" height=\"286\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-16-1.png 817w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-16-1-300x105.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2023\/12\/Count-Characters-in-Excel-16-1-768x269.png 768w\" sizes=\"(max-width: 817px) 100vw, 817px\" title=\"\"><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000;\"><b>Conclusion<\/b><\/span><\/p>\n<p>Whether you&#8217;re working with large datasets or simple <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/how-to-insert-an-excel-table\/\" target=\"_blank\" rel=\"noopener\"><strong>tables<\/strong><\/a>, understanding how to <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/count-characters-in-cells-with-excel-for-mac-ce48398b-2cf9-4ef5-b57e-c5e8e4745c8b#:~:text=To%20use%20the%20function%2C%20enter,the%20formula%20to%20other%20cells.\" target=\"_blank\" rel=\"nofollow noopener\"><strong>count characters<\/strong><\/a> in <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/free-microsoft-excel-online-course\/\" target=\"_blank\" rel=\"noopener\"><strong>Excel<\/strong><\/a> can save time and enhance your data analysis skills. In this article, we have covered three distinct methods \u2013 counting <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/excel-substitute-function\/\" target=\"_blank\" rel=\"noopener\">characters in a cell, counting characters in a range of cells using SUMPRODUCT and LEN functions<\/a>, and counting specific characters using LEN and SUBSTITUTE functions.<\/p>\n<p><span style=\"font-weight: 400;\">Learn more about Formulas with our <\/span><span style=\"font-weight: 400;\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/top-excel-formulas-function-examples-to-get-better-at-microsoft-excel\/\" target=\"_blank\" rel=\"noopener\"><strong>101 Advanced Excel Formulas &amp; Functions Examples<\/strong><\/a>.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel provides several built-in functions that make it easy to count characters for different purposes. It can be used to determine the number of individual characters (letters, numbers, symbols, and spaces) within a cell, a range of cells, or specific characters within the text in Excel. In this article, we will cover the following topics [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":33773,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[302,306,285,14,308],"tags":[1518,1520,1519],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33689"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=33689"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/33689\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/33773"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=33689"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=33689"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=33689"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}