Ask Your Question

How do I check a cell for a particular string?

asked 2017-01-02 22:35:38 +0200

DavidS gravatar image

For instance, I want to see if the contents of cell A1 is "Tempo" (without the quotes) or not. In another cell I have tried things like =EXACT(A1;"Tempo") but this doesn't work: it returns FALSE even when A1 contains the word Tempo.

What's the secret to doing this?

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-01-03 00:12:13 +0200

floris v gravatar image

Works for me ( Make very sure that you didn't type any spaces after the word in A1. The EXACT function only yields True when the two parameters are exactly the same, case sensitively.

If this answer helped you, please vote it with ✔ (here on the left). That will help other people with the same question.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-01-02 22:35:38 +0200

Seen: 70 times

Last updated: Jan 03 '17