I've got a tricky one, well for me anyway.

I need to classify a list of products into Hardware and Software. The
trouble is the items can be called Licensed Software, Security Software,
renewal Software, etc... Want I want to be able to do is do an IF formula
that categorizes a cell as Software if the phrase containes Software in it,
does that make sense?

Hardware I'm not to bothered with as if it doesent classify as Software then
it has to be Hardware (as all the software products state so somewhere in the
product name)

Apologies if this is a bit confusing.

Thanks