HOW TO TAKE FIRST TWO WORD FROM EXCEL

MY EXPECTED OP IS-
RAHI SPICESINV NO-RS-29/21-22 DYNAMIC AGRO INV NO-DAI-079/08/21-22 DYNAMIC AGRO INV NO-DAI-084/08/21-22 EXOTICA INTERNATIONALS INV NO-EI/21-22/78
FORMULA IS -
“=CONCATENATE(TRIM(LEFT(D2, FIND(”^",SUBSTITUTE(D2, " “, “^”,2)&”^"))),""+" “+”",""+“INV NO”+"",""+"-"+"",E2,""+" “+”",TRIM(LEFT(D3, FIND("^",SUBSTITUTE(D3, " “, “^”,2)&”^"))),""+" “+”",""+“INV NO”+"",""+"-"+"",E3,""+" “+”",TRIM(LEFT(D4, FIND("^",SUBSTITUTE(D4, " “, “^”,2)&”^"))),""+" “+”",""+“INV NO”+"",""+"-"+"",E4,""+" “+”",TRIM(LEFT(D5, FIND("^",SUBSTITUTE(D5, " “, “^”,2)&”^"))),""+" “+”",""+“INV NO”+"",""+"-"+"",E5)"

BUT HERE I GET ERROR IS ; EXPECTED , ^ CANNOT BE APPLIED TO OPENANDS TO TYPE STRING

Hi @Bhargavi_Lokapur

Can you elaborate your query bit more?
Can you share input ?

Regards
Gokul

my formula is “=CONCATENATE(D2,”"+" “+”",""+“INV NO”+"",""+"-"+"",E2,""+" “+”",D3,""+" “+”",""+“INV NO”+"",""+"-"+"",E3,""+" “+”",D4,""+" “+”",""+“INV NO”+"",""+"-"+"",E4,""+" “+”",D5,""+" “+”",""+“INV NO”+"",""+"-"+"",E5)"

i want to add TRIM(LEFT(D2, FIND("^",SUBSTITUTE(D2, " “, “^”,2)&”^")))
this formula in this above formula … but when i add this it gives me error

because i want here… party name with first two word…only…
when i put add this in original formula it gives me errror.