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

Data Analysis

  • Filter Data Based on Date in Excel
  • Add Outline to Data in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How To Perform and Interpret Regression Analysis in Excel
  • How to calculate correlation coefficient Correlation in Excel

References

  • How to get address of named range in Excel
  • To count total rows in a range in Excel
  • How to use Excel FORMULATEXT function
  • How to use Excel COLUMN Function
  • Complete List of Excel Lookup and Reference Functions, References and Examples

Data Validations

  • Excel Data validation date in specific year
  • Excel Data validation no punctuation
  • Excel Data validation must begin with
  • Excel Data validation exists in list
  • Excel Data validation must contain specific text

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

  • Excel If, Nested If, And/Or Criteria Examples
  • How to use Excel TRUE Function
  • IFS function: Description, Usage, Syntax, Examples and Explanation
  • How to return blank in place of #DIV/0! error in Excel
  • Not Equal To ‘<>‘ operator in Excel

Date Time

  • How to show last updated date stamp in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get fiscal year from date in Excel
  • TODAY function: Description, Usage, Syntax, Examples and Explanation
  • Calculate number of hours between two times in Excel

Grouping

  • Map inputs to arbitrary values in Excel
  • How to randomly assign data to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Group arbitrary text values in Excel
  • Categorize text with keywords in Excel

General

  • List worksheet index numbers in Excel
  • Find Most Frequently Occurring Word in Excel Worksheet
  • Index and match on multiple columns in Excel
  • How to calculate project complete percentage in Excel
  • Check if range contains a value not in another range in Excel
© 2025 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning