Possible to count the number of '+' appearing in an excel column?

I would like to improve my process to accommodate for changes in the future and would like to change the bot from finding “LP” keywords to the number of times ‘+’ plus signs appear within a row is that possible?

I get this error when replacing “LP” with “+” using the code shown above

hi @lmoham

can u show thw excel column please?

Heres the column for it, I would like to get the same results but finding ‘+’ plus signs instead of ‘LP’.

1 Like

(From row in outData.AsEnumerable() Where row.item(0).ToString.Contains(“+”) Select row.Item(0)).ToList()

you can use For each to print them and just do this to check Item.Count

Try this and let me know.

1 Like

Hi @lmoham

Please use the below method.


Feel free to reach us at any time if you have doubts. Thanks.

Happy Automation

1 Like


Check as below


Mark as solution if this helps you


1 Like

Thanks again and yes your code worked the way I desired!

Thanks to everyone chipping in too ^^

1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.