I have a spreadsheet that contains 20,000 cells.
I want to select all cells that contain "foobar".
How can I do this?
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.Sign up to join this community
Let's say you want to search for "foobar" in the
Use a IF formula with a condition based on
IF the range contains "foobar", return the cell, else we do nothing. You can return the cell data but also coordonnate with
=ROW() and =COLUMN()
You want to test every cells so I made an array with
Edit : this method is case-sensitive, space-sensitive, etc... try using