Previous Topic Next Topic

Scan for more than one word

Closed
excelformula - Aug 31, 2009 at 02:54 PM
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 - Aug 31, 2009 at 03:02 PM
Hello,
I have text in one cell and need to extract out several words and indicate each word with a value.

For instance: The coverage area drops calls.

We want to give coverage value 1
Drop a value of 2
Related:

1 response

Answer 1 / 1
sadgurl Posts 697 Registration date Thursday May 14, 2009 Status Member Last seen November 24, 2010 219
Aug 31, 2009 at 03:02 PM
Hye,

Try to split the string into an array and then loop the array content to compare for the chosen words

:)