Hello anyone,
I am trying to write a simple formula that will do the following...
I have text in columns A1:A100. I want to search for the word "wind" on each
line of text A1:A100. Needless to say it takes a long time to search each
line manually.
Then when the word "wind" has been found...I want to assign it a number
(like 6) in column B1:B100, whenever the word "wind" is found within the text
in column A. I would also like to find other key words like "about"
"portable" and "how to" (not case sensitive)...and also assign a number for
each. If none of my words comes up in a line of text, then it should not
put anything assigned to it.
--
Example of what I want to see
A B
wind power in homes 6
solar cells
about solar power 1
solar portable power 5
home solar
build wind system 6

It seems like it would be fairly easy to write a formula, but I guess I
just am not that adept at using excel formulas yet.
Any Help would be greatly appreciated. Thanks!!!!!!!!!!


thanks, cb