Hi All
This is my sample data and I've got so far but kinda stumped now.
"Compan ABC Black Sapphire Metallic Spray Paint - 12.5ml
Product Description
£10.40"
My Formula is: =CLEAN(MID(IFERROR(MID(A2,FIND("Compan",A2),56),""),1,56))
and this duly extracts: Compan ABC Black Sapphire Metallic Spray Paint - 12.5ml
However on my next line the sample data is:
"Compan ABCD Quartz Grey Metallic Spray Paint - 150ml
Product Description
£10.40"
and the same formula starts returning the main Description but then the words on the next line too - which I don't want.
Is there any way to terminate the Formula when it goes past the next line?
Bookmarks