=LEN(source-string)

Apple’s LEN function reference describes source-string as any value. The documented output is the number of graphemes in a string value. Our predictable exercises intentionally use text fields. LEN has just one argument, so the comma-versus-semicolon locale rule has no direct effect on the simplest =LEN(A2) example. When combining it with other multi-argument functions, Apple’s settings rule applies.

1. Create a Numbers table called References; put Reference text in A1 and Length in B1.
2. Type A2:A6 exactly as shown below. The spaces in A3 and A5 are deliberate; do not surround the entered text with quotation marks in the cell.
3. In B2 type =LEN(A2) and use Numbers’ formula-fill controls to create corresponding formulas down through B6. Confirm the references shift to the correct rows.

For the first row, A, B, -, 1, 0, and 2 are six graphemes. Café has four visible letters; Apple explicitly documents that a character with diacritics counts as one grapheme. The results were independently checked against the listed plain text; no Numbers application produced these values in this run.

A user pastes a reference value into A3 with unwanted exterior spaces. Keep A3 as M42 (exactly one ordinary space at each end). Compare:

=LEN(A3)

Expected: 5.

=LEN(TRIM(A3))

Expected: 3, because documented TRIM behaviour removes exterior spaces and the underlying reference M42 has three letters/digits. This is a computed expectation based on two official function specifications, not a native composite-formula test.

=LEN(A3)-LEN(TRIM(A3))

Expected: 2, the difference caused by the two surrounding spaces. For a working validation dashboard, use a helper column comparing raw and cleaned lengths; retain the original source text until your import is verified.

For an expected six-character reference format, an independent length check is:

=LEN(A2)=6

Expected: TRUE for AB-102, but length alone does not guarantee a correctly structured identifier. A malformed string of six characters would also pass. Combine with other checks if format matters.

• Whitespace counts: leading, trailing and repeated internal spaces contribute to LEN; use TRIM first only when those spaces are unintentional.
• Grapheme semantics: this Apple function is documented to count graphemes. Do not assume results are always identical to Python code-point lengths, Excel character counts or the number of UTF-8 bytes, especially with emoji sequences and combining marks.
• Imported values and numbers: Apple’s accepted argument is “any value,” but numeric formatting, localization and conversion to a string can affect meaningful length checks. Use an explicit text column for identifier validation rather than relying on numeric cell display.
• Blank cells and formula-generated empty strings: the effect in every historical release has not been verified in the native app; test a blank cell, a literal empty string, and a zero-length formula separately if this is business-critical.
• Character appearance: a multi-code-point emoji may be seen as one grapheme, while symbols and invisible characters can change counts in ways not obvious visually. The simple worked examples avoid these ambiguities.

If a reference appears to have length 3 but LEN reports 5, check both ends for ordinary spaces. If an imported identifier behaves differently, determine whether its cell is text rather than formatted number and inspect hidden characters. If copying the formula down gives identical values for every row, check for an accidentally fixed reference, wrong table or a selected range instead of a relative cell. Use the formula editor to select the actual source table rather than typing Excel Sheet1!A2 syntax in Numbers.

Documented against Apple’s Functions Help 15.4 page and overview on 2026-10-11. Apple supplies a shared function-help system for its spreadsheet and productivity apps, but this does not establish the earliest Numbers release supporting grapheme semantics, nor certify identical behaviour in all historical Mac, iPhone, iPad and iCloud.com versions. The examples were not natively executed. The sample is entered into the same Numbers table; in another table, insert the References table’s appropriate table-qualified cell reference through the formula editor.

Excel also has LEN, but Microsoft’s Excel LEN help documents compatibility-version details for surrogate pairs and variation selectors; Unicode text counting must not be assumed identical between Apple Numbers and every Excel workbook setting. Google Sheets and LibreOffice Calc have broadly similar text-length operations, yet results for complex Unicode characters, numeric formatting and date formatting warrant product-specific verification. The example’s plain ASCII lengths are portable in intent.

• TEXTAFTER — retrieve a portion of text after a delimiter.
• TEXTBETWEEN — obtain text bounded by delimiters.
• REGEX.EXTRACT — extract text with a pattern; punctuation in its official function name is preserved separately from its URL slug.

See the TRIM guide for space cleanup examples.

• Apple Numbers — function documentation
• Apple — TRIM
• Apple — Functions overview

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.