Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to Apply the Reverse Find or Search Function in Excel?
Generally, when we try to find a particular sentence, we always try to find it by using the first words of the text, but if we clearly understand the data, we can see most of the sentences will start with the same words, but they always end with different words. So, by searching for sentences using the last words rather than the first words, we can return fewer results than if we used the first words. So, we can list the last words of the sentences using this process.
Read this tutorial to learn how you can apply the Reverse Find or Search function in Excel. This process uses the formulas supported by Excel to complete the task. The keywords in the formula are "trim" and "substitute".
Applying the Reverse Find or Search Function Using Formula
Here, we will first get the first result using the formula, then use the auto-fill handle to get all the results. Let us see a simple process to apply the reverse find or search function using the formulas in Excel in a fast and efficient way.
Step 1
Let us consider an Excel sheet where the data present in the sheet is similar to the data present in the below screen shot.
Now click on an empty cell, which will be cell C2 in our case, and enter the formula as =TRIM(RIGHT(SUBSTITUTE(TRIM(A1), " ", REPT(" ", 99)), 99)) in the formula box and hit the "Enter" button to get the first result, as shown in the below image.
Step 2
As we can see, we have achieved the first result. We can get all the other results by dragging down from the right corner of the first result.
Conclusion
In this tutorial, we used a simple example to demonstrate how we can apply the Reverse Find or Search function in Excel to highlight a particular set of data.
2K+ Views
