How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask John D Your Own Question
John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

Good day,Ive looked through several forums and pertinent

Customer Question

Good day,
I've looked through several forums and pertinent threads but can't seem to find an agreed-upon solution for this task:

Return: sheet_name, file_name, fullfilepath_name

For all excel files containing a specified string. String doesn't have to be a full match -- e.g., A search for "world, my name" would include in the results a file that has, in one of its multiple worksheets, a cell with the text string "Hello world, my name is Katherine!"

Thanks in advance for any help you may be able to provide!
Submitted: 4 years ago.
Category: Microsoft Office
Expert:  ITGuyDave replied 4 years ago.

Hello, my name is XXXXX XXXXX I'll try to help you with your Excel issue.


So you need to search multiple files for text in a cell correct?

Expert:  ITGuyDave replied 4 years ago.
Try this program. It's free, and has some good reviews.
Customer: replied 4 years ago.

This didn't work. I tried searching text strings that I knew were contained in excel cells of files and got no search results.


Other ideas?

Expert:  ITGuyDave replied 4 years ago.
Sorry, that's all I that I know of. I will Opt Out so that other experts can help you. Best of luck!
Expert:  John D replied 4 years ago.
Are you looking for formulas that return sheet_name, file_name, fullfilepath_name