How to Count Characters in Excel on PC or Mac

This wikiHow teaches you how to find the number of characters in a cell or group of cells using Microsoft Excel. Open the spreadsheet that contains the characters you want to count.

Method 1 of 2:

Counting Characters in One Cell

  1. Picture 1 of How to Count Characters in Excel on PC or Mac
    Open the spreadsheet that contains the characters you want to count.
  2. Picture 2 of How to Count Characters in Excel on PC or Mac
    Click an empty cell. This is the cell where the number of characters will appear.
  3. Picture 3 of How to Count Characters in Excel on PC or Mac
    Type =LEN(cell name). Replace 'cell name' with name of the cell you want to count.
    1. For example, if you want to count the characters in cell C4, the formula should say =LEN(C4)
  4. Picture 4 of How to Count Characters in Excel on PC or Mac
    Press ↵ Enter or ⏎ Return. The number of characters in the cell now replaces the formula.
Method 2 of 2:

Counting Characters in Multiple Cells

  1. Picture 5 of How to Count Characters in Excel on PC or Mac
    Open the spreadsheet that contains the characters you want to count.
  2. Picture 6 of How to Count Characters in Excel on PC or Mac
    Click an empty cell. This is the cell where the number of characters will appear.
  3. Picture 7 of How to Count Characters in Excel on PC or Mac
    Type =SUMPRODUCT(LEN(Cell1:Cell2)). Replace 'Cell1' with first cell in the range you want to count, and 'Cell2' with the last in the range.
    1. For example, if you want to count the characters in cells C2 through C51, the formula should say =SUMPRODUCT(LEN(C2:C51))
  4. Picture 8 of How to Count Characters in Excel on PC or Mac
    Press ↵ Enter or ⏎ Return. The number of characters in the specified range now appears in the cell.
Update 04 March 2020
cellcharacterscountwant

You should read it

Maybe you are interested

Category

System

Mac OS X

Hardware

Game

Tech info

Technology

Science

Life

Application

Electric

Program

Mobile