Excel Formula

[MartVersteeg]

Hi, 

I'm trying to write a formula which checks if a certain cell contains x word. This word is automatically filled in via a Microsoft Power Automate flow. Which adds a row every time the connected Microsoft Form is filled in. 

I currently have the following formula =SUM(IF(AB2:AB2="besteld";1;0)). The problem I'm trying to solve is when people fill the form out on their phone they sometimes add a space after the word. As in "besteld ". When this happens my current formula doesn't add a "1" in the used cell. 

Does anyone know how to solve this? As in a different formula etc.. Let me know!

[#2]

@MartVersteeg 

As variant

=1*(TRIM(AB2)="besteld")

[#3 · Accepted solution]

@MartVersteeg 

Try this formula:

=IF(ISNUMBER(SEARCH("besteld";AB2));1;0)

(There is no need to use SUM or AB2:AB2 here)

[#4]

This works! Thanks for helping! Didn't know I don't need to use the SUM, still learning the ropes of excel formulas : )