Numbers HYPERLINK Function: URL Labels, Email Links and Checks

• Introduced: The original introduction release is not established by the checked official references.
• Availability: Documented for Numbers in the Apple Functions Help 15.4 edition; no final supported-version endpoint is established.
• Scope: The help edition is not an app build number. Historical Mac, iPad, iPhone and iCloud parity remains separately unverified.
• Checked: October 14, 2026, against the official HYPERLINK reference. Examples were independently calculated or traced from the documented text contract; no native Numbers test was performed.

HYPERLINK(url, [link-text])

Apple’s function entry requires a properly formatted URL string. The optional second string is the clickable label. If it is omitted, the URL itself is displayed. Brackets indicate optional syntax; do not type them.

The documented actions are opening a webpage or starting a new email message. The target operating system’s default browser or email application handles the click. These formula examples do not establish every URL scheme, exported-file behavior or mobile interaction.

Create ReferenceLinks with eight columns and eight rows. Use one header row and no header columns. Put URL, Label, Link, Plain label, Label length, Label agrees, URL label and URL agrees in A1:H1.

Enter these complete URLs as text in A2:A4:

• A2: http://www.apple.com
• A3: https://support.apple.com/guide/functions/convert-ffa56f533f/15.4/web/1.0
• A4: https://support.apple.com/guide/functions/plaintext-ffa03f1ed2ba/15.4/web/1.0

Put Apple, Unit reference and Text reference in B2:B4 respectively. Do not type quotation marks around values entered directly in cells. Keep all generated results out of A:B.

Enter these formulas in row 2 and fill C2:H2 down through row 4:

C2: =HYPERLINK(A2,B2)
D2: =PLAINTEXT(C2)
E2: =LEN(D2)
F2: =EXACT(D2,B2)
G2: =HYPERLINK(A2)
H2: =EXACT(PLAINTEXT(G2),A2)

G displays each complete A-column URL because its second argument is omitted. D strips the link’s rich-text attributes and returns the displayed label. Apple’s PLAINTEXT example explicitly demonstrates that behavior with a hyperlink labeled Apple.

LEN counts the label’s graphemes, including its space. EXACT checks case and content. Neither helper visits the target, checks whether it still exists, or extracts a hidden destination from the friendly label.

Copy ReferenceLinks as RenamedLabel. Change only B3 to Convert units. C3 and D3 now display Convert units, E3 becomes 13, and F3 remains TRUE. A3 and the URL displayed in G3 remain unchanged.

This is useful when a report needs concise navigation text, but it also explains why the label cannot be treated as evidence of the destination. Before following a link from an unfamiliar workbook, inspect its actual URL rather than relying on words such as Apple or Approved.

Create SameLabel, with six columns and six rows. Copy the original ReferenceLinks A3:A4 into A2:A3 as plain URL text. Put Reference in both B2 and B3. Use C2 =HYPERLINK(A2,B2) and D2 =PLAINTEXT(C2), then fill C2:D2 through row 3.

Put =EXACT(D2,D3) in F2 and =EXACT(A2,A3) in F3. Expected results are TRUE and FALSE. Both visible labels are Reference, but one destination is the CONVERT page and the other is the PLAINTEXT page.

F4 =LEN(D2) is 9. Copy SameLabel as SpecificLabels and change B2 to Convert units and B3 to Plain text. F2 becomes FALSE, F3 remains FALSE and F4 becomes 13. The more descriptive labels improve readability without changing either URL.

For a durable link register, retain separate source columns for the destination and label. PLAINTEXT is appropriate when ordinary label text is wanted; it is not a URL-extraction function.

Create LinkPresence, with four columns and six rows. Enter the original CONVERT URL in A2, ="" in A3 and =" " in A4. The last two are formulas producing empty text and three ordinary spaces. Enter Unit reference, Missing and Spaces in B2:B4.

In C2 put =IF(LEN(TRIM(A2))=0,"Missing URL",HYPERLINK(A2,B2)) and fill through C4. Put =PLAINTEXT(C2) in D2 and fill through D4. Expected D values are Unit reference, Missing URL, Missing URL.

TRIM and IF implement an explicit empty-or-space policy. The guard does not prove that every nonempty string is a valid or safe URL. It also does not normalize or repair a destination: the original A2 is passed to HYPERLINK unchanged. Exact behavior for malformed URLs, errors and unexpected input types is not defined by the short function entry.

On a separate EmailExample table with three columns and five rows, enter Apple’s literal example in B2:

=HYPERLINK("mailto:marina@example.com?subject=Quote Request","Get Quote")

The documented label is Get Quote. If activated, Apple describes a new message addressed to the example recipient with subject Quote Request, using the default email application. Creating or clicking that link is not evidence that an email was sent. No click or message delivery was performed for this guide.

Put =PLAINTEXT(B2) in B3 for Get Quote, then =LEN(B3) in B4 for 9. The example address is a demonstration value, not a real contact. Real mail links require deliberate recipient, subject and encoding choices; this simple example does not establish arbitrary query-string escaping or email-client parity.

These formulas use English function names and comma separators. In Numbers, enter = to open the formula editor, then enter the expression. The examples use uniquely named tables, one header row, zero header columns and zero footer rows unless stated otherwise. Keep input and result cells separate.