Hi there, I have tried the formula =LEFT(M2,FIND("Part",M2)-1) to pull the part number I need out of the text in the cell, but I get different errors. I have three different text string conditions, they are as follows; Case1: string= Tooling for T141120001 ,MY 14 (I need the T141120001. Case 2: string= Tooling for 68104645AA ,MY 15. I need 68104645AA. Case 3: string= CN 21009S22 For Part 04726367AC MY 14 and I need 0472636AC. Any ideas?