Is there a way to find and list all cells that contain a certain text without using the simple excel find feature?
For example, in A1:R200, I want to find the location of and contents of all cells containing the word test. Sometimes it is XXtest or aa test or testb. There are hundreds of these possibilities and I want to find and list all of them.
Is it possible for a formula to do this?
Thanks
You could do a conditional formatting (=ISNUMBER(SEARCH("test", A1)) ) to color all cells containing test.
I have not been able to come up with a formula that pulls all these cells or would give their addresses. I'm sure there must be one.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Not sure a formula can accomplish this but a UDF certainly can.
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Struggling with variations of
ADDRESS(ROW(A1:C6),COLUMN(A1:C6))
INDEX(ADDRESS(ROW(A1:C6),COLUMN(A1:C6)),)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks