Hi,
I have list of article name for which i want to run a formula.
1. Article Name: A1 = Philips QP2525/10 Cordless OneBlade Hybrid Trimmer
Formula: LEFT(" A1",(FIND(" ","A1",1)-1))
Result: Philips
2. Article Name: A2 = QP2525/10 Cordless OneBlade Hybrid Trimmer
Formula : IF(ISNUMBER(FIND("QP2525/10",A2)),"Philips")
What formula i can write so for both the Cell A1 & A2 same formula can produce correct result.
Bookmarks