Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to retrieve first match between two ranges in Excel
  • Vlookup Examples in Excel
  • How to use Excel VLOOKUP Function
  • How to use Excel TRANSPOSE Function
  • Count unique text values with criteria

Data Analysis Examples

  • Conflicting Multiple Conditional Formatting Rules in Excel
  • Calculate Conditional Percentile ‘IF’ in table in Excel
  • Conditional Formatting Rules in Excel
  • How to perform a t-Test in Excel
  • Get column name from index in Excel Table

Data Validation Examples

  • Excel Data validation must contain specific text
  • Excel Data validation allow uppercase only
  • Excel Data validation must not contain
  • Data validation must not exist in list
  • Excel Data validation number multiple 100

Find function vs Search function in Excel

by

The FIND function and the SEARCH function are very similar to each other. This example shows the difference.

1. To find the position of a substring in a string, use the FIND function. FIND is case-sensitive.

2. To find the position of a substring in a string, use the SEARCH function. SEARCH is case-insensitive.

Worked Example:   Get workbook name and path without sheet in Excel

Note: string “excel” found at position 11. Even though it’s actually the string “Excel”

3. The SEARCH function is more versatile. You can use wildcard characters when you use this function.

Worked Example:   Count cells that do not contain many strings in Excel

Note: A question mark (?) matches exactly one character. An asterisk (*) matches a series of zero or more characters.

4. One other interesting point to mention about the FIND and the SEARCH function is that they have a 3rd optional argument. You can use this argument to indicate the position, counting from the left, at which you want to start searching.

Worked Example:   Split dimensions into three parts in Excel

Note: string “o” found at position 5.

Note: string “o” found at position 7 (started searching at position 6).

Post navigation

Previous Post:

SUBSTITUTE function vs REPLACE function in Excel

Next Post:

How to Remove Leading Spaces in Excel

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
  • How to strip protocol and trailing slash from URL in Excel
  • How to abbreviate names or words in Excel
  • How to calculate Number of Instances in Excel
  • How to remove trailing slash from url in Excel
  • Extract last name from full name — Manipulating NAMES in Excel
  • Roll back weekday to Friday base on a particular date in Excel
  • Get date from day number in Excel
  • How to calculate next day of week in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • MINUTE function: Description, Usage, Syntax, Examples and Explanation
  • Bond valuation example in Excel
  • CUMPRINC function: Description, Usage, Syntax, Examples and Explanation
  • Calculate interest for given period in Excel
  • Future value vs. Present value examples in Excel
  • Calculate payment periods for loan in Excel
© 2022 xlsoffice . All Right Reserved. | Teal Smiles