How to Count Characters in Excel on PC or Mac

Method 1 of 2:

Counting Characters in One Cell

  1. How to Count Characters in Excel on PC or Mac Picture 1
    Open the spreadsheet that contains the characters you want to count.
  2. How to Count Characters in Excel on PC or Mac Picture 2
    Click an empty cell. This is the cell where the number of characters will appear.
  3. How to Count Characters in Excel on PC or Mac Picture 3
    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. How to Count Characters in Excel on PC or Mac Picture 4
    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. How to Count Characters in Excel on PC or Mac Picture 5
    Open the spreadsheet that contains the characters you want to count.
  2. How to Count Characters in Excel on PC or Mac Picture 6
    Click an empty cell. This is the cell where the number of characters will appear.
  3. How to Count Characters in Excel on PC or Mac Picture 7
    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. How to Count Characters in Excel on PC or Mac Picture 8
    Press Enter or Return. The number of characters in the specified range now appears in the cell.
4.8 ★ | 4 Vote

May be interested

  • How to Block Websites on Mac Browsers with Aobo FilterPhoto of How to Block Websites on Mac Browsers with Aobo Filter
    how do you block those unwanted websites in your child's mac? the first way that comes into your mind may be using the built-in parental controls. however, you can also find thousands of ways to bypass parental controls while you search in...
  • How to Find Your MacBook's Serial NumberPhoto of How to Find Your MacBook's Serial Number
    need to inventory your macbook? to do that, you probably want its serial number. click the apple menu on the far left of your screen and select 'about this mac'.
  • How to Quickly Open the Notification Center on a MacPhoto of How to Quickly Open the Notification Center on a Mac
    to quickly open notification center on mac, from any app or menu, click on the notification center icon ('⋮≡') in the menu bar at the upper right corner of the screen. move the cursor to upper right corner of the screen.
  • How to Speed Up a MacPhoto of How to Speed Up a Mac
    this wikihow shows you several ways to speed up your mac. a slow mac can be caused by several issues, but turning off visual effects, closing resource-heavy programs, updating your os, and managing your startup programs are a few ways to...
  • How to Set Mac Keyboard ShortcutsPhoto of How to Set Mac Keyboard Shortcuts
    you can create keyboard shortcuts on your mac from the keyboard section of the system preferences menu. you can use this menu to make shortcuts for a variety of different types of commands. you can also use the app shortcuts tool to create...
  • How to Sync iCloud Apps on a MacPhoto of How to Sync iCloud Apps on a Mac
    to sign into icloud on your mac, click the apple menu → click system preferences → click icloud → enter your apple id and password. by signing into your mac with your apple id, you'll be able to download any apps you've previously downl...