Hello all,

Sorry for the nub question. I have done some digging and found this page on your site:
http://www.excelforum.com/excel-work...ther-cell.html

It showed a formula that has indeed worked :
=IF(ISNUMBER(SEARCH("16x20",A2)), "Baseball,BaseballPhotos16x20", IF(ISNUMBER(SEARCH("8x10",A2)),"Baseball,Basebal lPhotos8x10",""))

I have copied and pasted and changed the relevant text but....I need to add more.
The logical step was to re-patse the formula and again, change the relevant parts but i cant 'finish' the formula?

Q: How do i add further 'rules' and then finish the text string?

Many thanks,