Word search in Excel
Closed
Nate
-
Jun 6, 2011 at 09:11 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2011 at 01:40 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 6, 2011 at 01:40 PM
Is there a function that can search the entire worksheet (all columns & rows) for a given word that the user inputs and then the output would be the cell(s) location(s) that contains the user supplied word that was the input? For example: A1 is the cell that all queried words will be entered by the user and B1 is where the results are returned. If we are wanting to find all locations of the word "Cost" which are in G8, Y2 and F26. Then after Excel performs the search it would return in B1 "G8,Y2,F26". Is this something that's possible? Thank you so much for the help!
Nate
Nate
Related:
- Word search in Excel
- Number to word in excel - Guide
- Word apk for pc - Download - Word processors
- How to search for a word on a page - Guide
- Number to text in word - Guide
- Backspace not working in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 6, 2011 at 01:40 PM
Jun 6, 2011 at 01:40 PM
A simple find can give you that. If you are looking on some sheets the results be displayed then you have to write a macro.