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

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 Numbers
    • Numbers at a glance
    • Create or open a spreadsheet
    • Replace template placeholders
    • Organize a spreadsheet with sheets
    • Customize your app
    • Undo and redo changes
  • Add and edit tables
    • Add and delete tables
    • Working with rows and columns
    • Add content to table cells
    • Format table cells
    • Create a custom cell format
    • Add controls to cells
    • Merge and 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
    • Move, resize, and lock a table
    • Sort data in a table
    • Filter data
  • Enter 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 and edit charts
    • Add or delete a chart
    • Scatter charts and bubble charts
    • Interactive charts
    • 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
  • Add images, shapes, and media
    • Objects overview
    • Add and edit images
    • Add and edit shapes
    • Add video and audio
    • Change the look of an object
    • Create object styles
    • Resize, rotate, and flip an object
    • Align and position objects
    • Layer, group, and lock objects
  • Add, edit, and format text
    • Add text
    • Copy and paste text
    • Change the look of text
    • Align text
    • Adjust character spacing and formatting
    • Add color or a border to a text box
    • Check spelling
    • Find and replace text
    • Replace text automatically
    • Add comments and highlight text
    • Create bulleted and numbered lists
    • Format punctuation
    • Use paragraph styles
    • Format Chinese, Japanese, or Korean text
  • Manage spreadsheets
    • Save and rename a spreadsheet
    • Save a spreadsheet in another format
    • Lock a spreadsheet
    • Protect a spreadsheet with a password
    • Add custom templates
    • Delete a spreadsheet
    • Move a spreadsheet to or from iCloud
  • Share and print
    • Use iCloud with Numbers
    • Share and edit a spreadsheet on iCloud
    • Send a copy of a spreadsheet
    • Print a spreadsheet
    • Transfer files using iTunes
  • Keyboard shortcuts
Help for Apple products Copyright © 2014 Skydocu Inc. All rights reserved.