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

Data Analysis

  • Working With Tables in Excel
  • How to combine 2 or more chart types in a single chart in Excel
  • How to create Checklist in Excel
  • Conditional Formatting Rules in Excel
  • Excel Pie Chart

References

  • How to get last row in mixed data with blanks in Excel
  • How to get relative column numbers in a range in Excel
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel VLOOKUP Function
  • Two-way lookup with VLOOKUP in Excel

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation require unique number
  • Excel Data validation must not contain
  • Excel Data validation date in specific year
  • Excel Data validation allow uppercase only

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.

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.

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.

Note: string “o” found at position 5.

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

Post navigation

Previous Post:

VLOOKUP without #N/A error 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

Logical Functions

  • AND function: Description, Usage, Syntax, Examples and Explanation
  • NOT function: Description, Usage, Syntax, Examples and Explanation
  • How to use Excel AND Function
  • How to use Excel FALSE Function
  • TRUE function: Description, Usage, Syntax, Examples and Explanation

Date Time

  • Display the current date in Excel
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • Extract time from a date and time in Excel
  • Convert date to month and year in Excel
  • Convert date to text in Excel

Grouping

  • If cell contains one of many things in Excel
  • How to randomly assign people to groups in Excel
  • Running count group by n size in Excel
  • Map text to numbers in Excel
  • Group times into unequal buckets in Excel

General

  • Convert column letter to number in Excel
  • Basic text sort formula in Excel
  • Check if range contains a value not in another range in Excel
  • Subtotal by invoice number in Excel
  • Excel Autofill Cell Ranges, Copy, Paste
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning