Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to Create Area Chart in Excel
  • Conditional Formatting Color Scales Examples in Excel
  • How To Sort One Column or Multiple Columns in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • How to create Checklist in Excel

References

  • Count unique text values with criteria
  • Create hyperlink with VLOOKUP in Excel
  • Approximate match with multiple criteria in Excel
  • How to use Excel MMULT Function
  • How to use Excel INDIRECT Function

Data Validations

  • Excel Data validation require unique number
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Data validation must not exist in list
  • Excel Data validation must begin with

Advanced Find Features in Excel

by

This chapter teaches how to incorporate special characters with find option.

A question mark (?) matches exactly one character. For example, F?rrari will find Ferrari, Forrari, Farrari, etc. An asterisk (*) matches a series of zero or more characters. For example, F*rrari will find Ferrari, Foorrari, Faaaaaarrari, etc.

To access some more advanced find features in Excel, execute the following steps.

1. Click on Options in the ‘Find and Replace’ dialog box.

2. Type the text you want to find. For example, type Ferrari.

3. Select Workbook from the Within drop-down list to find occurrences across all the worksheets.

4. Checking “Match case” will make your search case-specific. For example, it will only find Ferrari and not ferrari.

5. Checking “Match entire cell contents’ will only find cells which contain exactly “Ferrari”. For example, cells that contain “Car Ferrari”, “Ferrarii” or even “Ferrari ” will not be found.

 

Post navigation

Previous Post:

COSH function: Description, Usage, Syntax, Examples and Explanation

Next Post:

Excel Data validation require unique number

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • TRUE function: Description, Usage, Syntax, Examples and Explanation
  • AND function: Description, Usage, Syntax, Examples and Explanation
  • Nested IF function example in Excel
  • Not Equal To ‘<>‘ operator in Excel
  • How to return blank in place of #DIV/0! error in Excel

Date Time

  • How to calculate Quarter of Date in Excel
  • Add decimal minutes to time in Excel
  • Check If Two Dates are same month in Excel
  • Convert text timestamp into time in Excel
  • Get date from day number in Excel

Grouping

  • Group times into unequal buckets in Excel
  • Group arbitrary text values in Excel
  • Calculate conditional mode with criteria in Excel
  • Map inputs to arbitrary values in Excel
  • Group numbers with VLOOKUP in Excel

General

  • Count cells that do not contain errors in Excel
  • How to get amount with percentage in Excel
  • Check if multiple cells have same value with case sensitive in Excel
  • Excel Operators
  • Count cells that contain errors in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning