LOOKS THE SAME. IS IT?

Find the hidden difference.

Two spreadsheet values won’t match? Inspect the exact characters, including invisible spaces.

Local by designYour text stays in this browser.
01   Your two valuesPaste one cell value into each field.
0 / 10,000 UTF-16 units
0 / 10,000 UTF-16 units

Exact text equality only. Spreadsheet formulas may use different matching rules. Neither value is cleaned or replaced.

02   What we found

Your explanation will appear here
A regular space and a non-breaking space can look identical. We’ll show where the values first diverge.
ONE SPACE CAN MAKE A DIFFERENCE

Why TRIM can leave two names looking the same

Suppose a copied spreadsheet cell contains the fictional name below. The names look alike, but the space between the words is different.

Value A · copied text

Mina Patel

Mina\u00A0Patel

Value B · typed text

Mina Patel

Mina\u0020Patel

The first difference is at position 5: A contains a non-breaking space (U+00A0); B contains a regular space (U+0020). Replacing just U+00A0 with a regular space makes these two example values exactly equal.

Excel’s TRIM function does not remove U+00A0 by itself. A targeted formula is =SUBSTITUTE(A1,UNICHAR(160)," "). Put it in another cell, replace A1 with the source cell, and check the result. It replaces non-breaking spaces only; it is not a general cleanup formula. Microsoft explains the TRIM limitation.

Inspect your two values

A focused explanation, with your originals intact

Start at the first difference

See a code point and a name where known, plus a short escaped excerpt. Regular spaces, non-breaking spaces, zero-width spaces and line breaks become visible without changing the values.

Look-alike is not equal

Accents can have different Unicode encodings. Emoji can contain meaningful joiners. This tool reports exact text differences and a few supported explanations; it does not merge names, identify people, or certify text as safe.

Keep spreadsheet rules in mind

This checks the text you paste, not cell formatting, formulas, numeric types or spreadsheet lookup behavior. A browser or source application may already have transformed text before it reaches the clipboard.

Your values stay in this browser.

Inspection runs locally. We do not upload your text or put it in a link, cookie, or browser storage. Copying or downloading a report is your choice; that report includes the complete values as escaped text. Refreshing clears the inputs.

Optional Google Analytics and Statsig measure visits and tool actions using controlled categories and coarse buckets. For US visits, analytics are enabled by default unless you decline. Elsewhere, including when location is unknown, analytics stay off unless you allow them. Global Privacy Control and Do Not Track keep measurement off. Use Analytics preferences to change your choice; the tool works either way.

Analytics never receive your values, characters, code points, positions, formulas, clipboard contents, or raw errors. Providers may receive connection/device information and a browser identifier when measurement is enabled. Normal hosting requests still happen. Read the full privacy notice.