Using function SEARCH in Excel to find the position of a substring within another string. Jaw SEARCH is not case sensitive and supports wildcards.
Join the channel Telegram belong to AnonyViet π Link π |
How to use the SEARCH function in Excel
1. The SEARCH function below finds the string βroβ at position 4.
2. The SEARCH function is not case sensitive. The SEARCH function below finds the string βexcelβ, βExcelβ, βEXCELβ, βEXcelβ, β¦
The SEARCH function supports wildcard characters. The question mark (?) represents a character. Asterisk
represents an empty string or multiple characters.
Lesson 146: How to use the SEARCH function in Excel 13
Lesson 146: How to use the SEARCH function in Excel 14
Lesson 146: How to use the SEARCH function in Excel 15
Lesson 146: How to use the SEARCH function in Excel 16
The article achieved: 5/5 β (100 votes)
Source: Lesson 146: How to use the SEARCH function in Excel
β TechtipsnReview