English
Change Language
  • English
  • Bahasa Indonesia
  • Bahasa Melayu
  • Català
  • Čeština
  • Dansk
  • Deutsch
  • Español
  • Français
  • Hrvatski
  • Italiano
  • Magyar
  • Nederlands
  • Norsk (bokmål)‎
  • Polski
  • Português
  • Português (Portugal)‎
  • Română
  • Slovenčina
  • Suomi
  • Svenska
  • Tiếng Việt
  • Türkçe
  • Ελληνικά
  • Русский
  • Українська
  • עברית
  • العربية
  • ภาษาไทย
  • 한글
  • 日本語
  • 简体中文
  • 繁體中文
Pages logo Pages

String operators and wildcard characters

Ways to use the string operator and wildcards
The string operator (&) can be used in formulas, and wildcards (*,?,~) can be used…

Functions that accept conditions and wildcards as arguments
Some functions, such as SUM, operate on entire ranges. Other functions, such as SUMIF, operate…

  • Get started in Pages
    • Pages at a glance
    • Create and open a document
    • Undo and redo changes
    • Quick navigation
    • Customize the toolbar
    • Zoom a document or view Pages full screen
  • Edit text
    • Add text
    • Copy and paste text
    • Change the look of text
    • Adjust character spacing and formatting
    • Use paragraph styles
    • Create bulleted and numbered lists
    • Create links for websites and email addresses
    • Format punctuation
    • Format Chinese, Japanese, or Korean text
    • Use bidirectional text
  • Format documents
    • Set paper size and orientation
    • Add, delete, and rearrange pages
    • Set margins
    • Change the flow of text
    • Convert the document type
    • Add headers, footers, and page numbers
    • Create sections
    • Add a background color and border
    • Align text
    • View formatting marks and layout
    • Show and hide rulers
    • Add footnotes and endnotes
    • Use EndNote and MathType
    • Add a table of contents
  • Add images, shapes, and media
    • Anchor objects to the page or to text
    • Add and edit images
    • Add and edit shapes
    • Add lines and arrows
    • Add video and audio
    • Add a caption to an object
    • Add and align text in an object
    • Place objects in the background
    • Change the look of an object
    • Use object styles
    • Resize, rotate, and flip an object
    • Set ruler preferences
    • Use alignment guides
    • Align and position objects
    • Layer, group, and lock objects
  • Add tables and charts
    • Tables
      • Add and delete tables
      • Add rows and columns
      • Add and edit table cell content
      • Format table cells
      • Create a custom cell format
      • Merge and unmerge cells
      • Add a comment to a cell
      • Add images and other objects to table cells
      • Add conditional highlighting to cells
      • Change the look of a table
      • Change the look of table text
      • Save a table as a new style
      • Resize, move, and lock a table
      • Format tables for bidirectional text
      • Sort data in a table
    • Formulas and functions
      • Calculations
      • Types of arguments and values
      • String operators and wildcard characters
        • Ways to use the string operator and wildcards
        • Functions that accept conditions and wildcards as arguments
    • Charts
      • Add and delete a chart
      • Move, resize, and rotate a chart
      • Modify chart data
      • Adjust a chart’s markings and labels
      • Change a chart’s type
      • Change the look of a chart
      • Save a chart as a new style
  • Use writing and editing tools
    • Check spelling
    • Look up words
    • Find and replace text
    • Replace text automatically
    • Add comments and highlight text
    • Show word count and other document statistics
    • Track changes
  • Manage documents
    • Save and rename a document
    • Locate a document
    • Save a document in another format
    • Lock a document
    • Password-protect a document
    • Add custom templates
    • Move a document to or from iCloud
    • Delete a document
  • Share and print documents
    • Use iCloud with Pages
    • Share and edit a document with others
    • Send a copy of a document
    • Print a document
    • Print envelopes, labels, and business cards
    • Share files over a remote server
    • Transfer files using iTunes
  • Keyboard shortcuts
Help for Apple products Copyright © 2014 Skydocu Inc. All rights reserved.