Ask Your Question

How do I check a cell for a particular string? [closed]

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 reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-09-20 11:23:23.266985

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

Question Tools

1 follower


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

Seen: 124 times

Last updated: Jan 03 '17