Character Counter: With and Without Spaces, Emoji and Excel

November 11, 2026 · 10 min read

Character Counter: Count Characters With and Without Spaces

A character counter tells you how long a piece of text is, measured in letters, digits, punctuation, spaces and line breaks. The catch is that "character" means different things to different tools. This guide shows which count you need and how to get that exact number online, in Docs, Word, Pages, spreadsheets and code.

What a Character Counter Counts (and What It Skips)

A character is any single unit of text: a letter, a digit, a punctuation mark, a space, a tab or a line break. Most counters report at least two totals, one with spaces and one without. Some add a third, letters only, which drops digits, punctuation and whitespace too.

Take one short string and run it through all three counts:

Hello, world!
CountResultWhat's included
Characters with spaces13Every letter, the comma, the space and the exclamation mark
Characters without spaces12The same, minus the single space
Letters only10H, e, l, l, o, w, o, r, l, d

Line breaks are where tools quietly disagree. Some count each one as a character, some skip them, and a few count a Windows line ending as two. If two tools differ by exactly the number of line breaks in your text, that's the reason.

Character Count With Spaces vs Without Spaces: Which One Do You Need?

A character counter with spaces is the default you want unless someone tells you otherwise. Form fields, database columns, social posts and SMS messages all store spaces, so a limit on those fields includes them.

The count without spaces shows up in briefs written by people who price or grade text. Some translation agencies quote per character without spaces, and some academic abstracts and grant forms specify it too. The wording of the brief decides it, so read it twice. "Max 1,500 characters" with no qualifier usually means spaces included. Application essays follow that default, as our guide to the AACOMAS, AMCAS and UCAS character limits shows.

The gap between the two numbers is roughly your word count, since most words are followed by one space. A 1,500-character paragraph with spaces usually lands between 1,200 and 1,250 without them.

Is 250 Characters the Same as 250 Words?

No. A word is several characters long, so 250 characters is a short paragraph, while 250 words fills most of a page. A rough rule for everyday English is 5 to 6 characters per word, counting the space after it. Technical writing, with longer terms, runs higher.

Here's the arithmetic with that rule, so you can redo it for your own limit:

Character limitDivide by 6Divide by 5Rough word range
2504250about 40 to 50 words
3005060about 50 to 60 words
1,440240288about 240 to 290 words
1,500250300about 250 to 300 words

Treat these as estimates for planning a draft. When a hard limit matters, paste the final text into a counter, because short words and long URLs swing the ratio a lot. If your limit is set in pages instead, our words-to-pages chart converts word counts by line spacing.

Why Do Emoji and Accented Letters Break Character Counts?

Software can count text in three different units, and each gives a different answer for the same emoji.

  • Code units are the chunks of an encoding. JavaScript strings use UTF-16, so String length counts 16-bit units, and many emoji take two.
  • Code points are the numbered Unicode characters. Python's len() counts these, and so does spreading a JavaScript string into an array.
  • Grapheme clusters are what a reader sees as one character. A family emoji is several code points joined by invisible connectors, but it shows as one symbol. Unicode's text segmentation rules define where each one starts and ends.

We ran each string below through Node.js and Python to get these numbers:

TextJS .lengthCode pointsGraphemes (what you see)UTF-8 bytes
café (single é)4445
café (e + accent)5546
🇯🇵 flag4218
👍🏽 skin tone4218
👨‍👩‍👧 family85118

The two cafés look identical on screen, yet one is a character longer to every tool except a grapheme counter. Text copied from some sources stores accents as separate combining marks, and you can't tell by looking.

If you're writing a character counter in JavaScript, count graphemes with Intl.Segmenter:

const text = "👨‍👩‍👧";
console.log(text.length);       // 8 (UTF-16 code units)
console.log([...text].length);  // 5 (code points)

const seg = new Intl.Segmenter("en", { granularity: "grapheme" });
console.log([...seg.segment(text)].length); // 1 (what the reader sees)

We prefer grapheme counts for anything a person reads, because they match what the writer sees on screen. Use code units or bytes only when you're checking against a system limit that's defined that way, such as a database column measured in bytes.

How to Count Characters in Google Docs, Word and Apple Pages

Word processors have a character length counter built in, so you don't need a free online character counter for text that already lives there. Each one shows both the with-spaces and without-spaces numbers, but hides them in a slightly different place.

Google Docs: choose Tools > Word count, or press Ctrl+Shift+C (Cmd+Shift+C on a Mac). The dialog lists pages, words, characters and characters without spaces. Tick Display word count while typing for a live box in the bottom left, and click it to see the other counts. Per Google's help page, a whole-document count leaves out headers, footers and footnotes. Our guide to the word counter for Google Docs covers the phone app and the document size cap.

Microsoft Word: click the word count in the status bar at the bottom of the window, on Windows or Mac, to open the Word Count box. On Windows, Review > Word Count opens it too. It shows Characters (no spaces) and Characters (with spaces), plus a checkbox for including text boxes, footnotes and endnotes.

Apple Pages (Mac): click View in the toolbar, then choose Show Word Count. A counter appears at the bottom of the page. Click the arrows on its right to switch to characters with spaces or without spaces, as Apple's Pages guide describes.

In all three, select a passage first to count just that selection.

Character Counter Formulas for Google Sheets and Excel

Spreadsheets count characters with LEN, which returns the number of characters in a cell, spaces included. The same formulas work in Google Sheets and Excel unless noted.

=LEN(A1)
=LEN(SUBSTITUTE(A1," ",""))
=SUMPRODUCT(LEN(A1:A10))

The first gives the total with spaces. The second deletes every space before counting, so it gives the count without spaces. The third adds up the lengths of a whole range, which is handy for a column of product titles or ad headlines.

SUBSTITUTE only removes ordinary spaces. Tabs, line breaks inside a cell and non-breaking spaces pasted from the web still count.

For letters only, Google Sheets has REGEXREPLACE:

=LEN(REGEXREPLACE(A1,"[^A-Za-z]",""))

This strips everything that isn't an A to Z letter, then counts what's left. Here's the limitation: accented letters such as é are stripped too, so it undercounts French, German or Spanish text. Google's docs say Sheets' regular expressions don't support Unicode character classes, so you'd have to add each accented letter to the bracket yourself.

Emoji are another trap. Microsoft's LEN documentation says only workbooks on Compatibility Version 2 count a surrogate pair, which is how most emoji are stored, as one character. Elsewhere many emoji count as two, and even Version 2 counts variation selectors separately. Test one emoji cell before you trust a column total.

Counting Characters in Markdown: Source Text vs What Readers See

If you draft in Markdown, the syntax inflates your count. Pound signs, asterisks and link URLs are characters in the source, but readers never see them.

## Pricing

Read the **full guide** at [our docs](https://example.com/docs/pricing).

Readers see a heading that says Pricing and one short sentence. The source is 84 characters long, but the rendered text is only 40, counting the line break after the heading. The link URL accounts for most of the gap.

So check what the limit applies to. A CMS field that stores raw Markdown counts the source. A preview, a social card or a printed page counts only the rendered text. To get the reader's number, strip the syntax first; our Markdown to plain text guide covers the ways to do it. The Markdown headings guide explains the heading syntax that adds those extra characters.

Testing an Online Character Counter Before You Trust It

You can check any character counter tool or browser extension in about 20 seconds. Paste this test text, keeping the line break:

Hi 👋 café
ok

A counter that counts what you see reports 12 characters with spaces, including the line break. If you get 13, it's counting UTF-16 code units, so the wave emoji counts as two. If you get 11, it skips line breaks. Neither is wrong, but you now know which question it answers.

On our site, the sentence counter runs in your browser and shows Characters, Characters (no spaces) and Letters alongside words and sentences.

Its Ignore markdown syntax toggle is on by default, so syntax such as link URLs and table pipes isn't counted. Switch it off to count the raw source. When you write in the editor, the status bar shows a live character count as you type. Platform limits, such as the length of a post on X or an SMS, are a separate question from how to count, so check each platform's own rules.

Quick Answers About Counting Characters

Getting a useful number from any character counter starts with the right question: with spaces or without, source or rendered text, what you see or what the system stores. Answer that, and the number stops changing between tools. For a quick count with and without spaces, paste your text into the sentence counter. To write in Markdown and watch the count update live, open the editor.