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

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 Keynote
    • Keynote at a glance
    • Create a new presentation
    • Open an existing presentation
    • Ways to view your slides
    • Show or hide the inspectors
    • Zoom a slide or view Keynote full screen
    • Customize the toolbar
    • Undo or redo changes
    • Use Handoff with Keynote
  • Add and organize slides
    • Add slides
    • Show or hide slide numbers
    • Reorder slides
    • Group slides
    • Skip a slide
    • Add and edit master slides
    • Change a presentation theme
    • Add custom themes
  • Add images, shapes, and media
    • Objects overview
    • Add and edit images
    • Add and edit shapes
    • Add video and audio
    • Change an object’s appearance
    • Create object styles
    • Resize, rotate, or flip an object
    • Set ruler preferences
    • Align and position objects
    • Layer, group, and lock objects
    • Add a link
  • Add, edit, and format text
    • Add text
    • Change the look of text
    • Use paragraph styles
    • Align text
    • Format lists
    • Adjust character spacing and formatting
    • Format punctuation
    • Add color or a border to a text box
    • Check spelling
    • Find and replace text
    • Add comments and highlight text
    • Set a default text box for a presentation
    • Use bidirectional text
    • Format Chinese, Japanese, or Korean text
  • Add tables and charts
    • Add tables
      • Add or delete a table
      • Add rows and columns
      • Add content to table cells
      • Format table cells
      • Create a custom cell format
      • Merge or unmerge cells
      • Add a comment to a cell
      • 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
      • Sort data in a column
      • Format tables for bidirectional text
    • Add 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
      • Add an equation with MathType
    • Add charts
      • Add or delete a chart
      • Move, resize, and rotate a chart
      • Modify chart data
      • Adjust chart markings and labels
      • Change a chart’s type
      • Change the look of a chart
      • Save and organize chart styles
  • Animate your slides
    • Add a Magic Move transition
    • Add transitions
    • Animate objects
  • Show your presentation
    • Play your presentation
    • Change to a links-only or self-playing presentation
    • Record a self-playing narration
    • Set presentation playback options
    • Present on a separate display
    • Use presenter notes
    • Rehearse your presentation
    • Use Keynote Remote
    • Highlight on slides as you present
  • Manage presentations
    • Save or rename a presentation
    • Locate a presentation
    • Save a presentation in another format
    • Save a presentation in package or single-file format
    • Lock a presentation
    • Add a password to a presentation
    • Move a presentation
    • Delete a presentation
  • Share and print presentations
    • Use iCloud with Keynote
    • Share and edit a presentation with others
    • Send a copy of a presentation
    • Print a presentation
    • Use iTunes to transfer files
    • Share files over a remote server
  • Keyboard shortcuts
    • Keyboard shortcuts
    • Keyboard shortcut symbols
Help for Apple products Copyright © 2014 Skydocu Inc. All rights reserved.