Hi all -

I have a CSV file with a column that contains some product names. Based on their contents, I would like to assign a category in the next column. So for example;

Apple Mac 123 Z Laptop

I would like to put Computers/Laptops/Apple in the next column (same row).

Can anyone point me toward a formula? I did a search in the forums and found a similar thread although the results being assigned were numbers... this was the forumla =IF(ISNUMBER(SEARCH("univ",H2)),1,0)

Many thanks!

Kate