Hi guys
Probably an easy one for you lot but here goes.
I have 1000 rows of text containing different things (text). I want to count the cell if it contains a text string.
eg Cell contains "Microsoft Navision". I want to search to see if the cell contains "nav" (just the string as opposed to the whole product)
Can anyone help?
Thanks in advance
Stu
Probably an easy one for you lot but here goes.
I have 1000 rows of text containing different things (text). I want to count the cell if it contains a text string.
eg Cell contains "Microsoft Navision". I want to search to see if the cell contains "nav" (just the string as opposed to the whole product)
Can anyone help?
Thanks in advance
Stu