ArtsAutosBooksBusinessEducationEntertainmentFamilyFashionFoodGamesGenderHealthHolidaysHomeHubPagesPersonal FinancePetsPoliticsReligionSportsTechnologyTravel
  • »
  • Technology»
  • Computers & Software»
  • Computer Software»
  • Office Software Suites»
  • Microsoft Office

How to count characters in multiple cells in Excel

Updated on June 20, 2013

To count the number of characters in a cell, we can use the LEN function.

Counting characters in one cell

For example, to count the number of characters in cell A1, type =LEN(A1)

Counting Characters in one cell
Counting Characters in one cell

Counting characters in multiple cells

To count the number of characters in multiple cells in Excel, simply combine the SUM and the LEN function. Type =SUM(LEN(A1:A6)) and finish by pressing CTRL + SHIFT + ENTER.

Counting characters in multiple cells
Counting characters in multiple cells

When you look at the formula bar, you'll notice the curly braces {}. You've just entered an Array formula in Excel!

Array Formulas

Array formulas are one of Excel's most powerful features. The number of characters of each cell are stored in Excel's memory. It look as follows:

{2;5;6;3;8;7}

This is called an array constant and it's used as an argument for the SUM function. Summing these numbers will give a total of 31 characters.

Learn more about Excel

Visit this website for more Microsoft Excel tips and tricks.

Comments

    0 of 8192 characters used
    Post Comment

    No comments yet.