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,
Bookmarks