https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86236#M37117 You can use the approach suggested by Tom, but if there are many lines, my experience is it takes BP much longer to do this sort of processing than simply copy-pasting a formula into Excel (and letting Excel do the job). You can use the Set Value in MS Excel VBO. For example MS Excel formula could be =IFERROR(TRIM(LEFT(B2;FIND(""-"",B2)-1));B2) - this should give the ""word1"". When passing it to Excel, you would pass ""=IFERROR(TRIM(LEFT(B2,FIND(""""-"""",B2)-1)),B2)"" - note the duplicated quotes to escape those quotes and the commas instead of semi-colons. You must use comma in functions (when using Set Value) even if your environment uses semi-colon. Fri, 09 Sep 2016 18:23:00 GMT RadoslavHiko 2016-09-09T18:23:00Z https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86234#M37115 Hey, I'm trying to split tekxt in a cell (word1 - word2) in excel. I found two formulas to do that, but I can't paste it in Excel (also can't set the value). Does anyone know a way to do this? Thnx. Fri, 09 Sep 2016 13:12:00 GMT https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86234#M37115 remko.bouwens 2016-09-09T13:12:00Z https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86235#M37116 It might be easier if you read the cell value, do the splitting in Blue Prism, then write the values back to the worksheet. Fri, 09 Sep 2016 15:57:00 GMT https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86235#M37116 TomBlackburn1 2016-09-09T15:57:00Z https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86236#M37117 You can use the approach suggested by Tom, but if there are many lines, my experience is it takes BP much longer to do this sort of processing than simply copy-pasting a formula into Excel (and letting Excel do the job). You can use the Set Value in MS Excel VBO. For example MS Excel formula could be =IFERROR(TRIM(LEFT(B2;FIND(""-"",B2)-1));B2) - this should give the ""word1"". When passing it to Excel, you would pass ""=IFERROR(TRIM(LEFT(B2,FIND(""""-"""",B2)-1)),B2)"" - note the duplicated quotes to escape those quotes and the commas instead of semi-colons. You must use comma in functions (when using Set Value) even if your environment uses semi-colon. Fri, 09 Sep 2016 18:23:00 GMT https://community.blueprism.com/t5/Product-Forum/Paste-formula-in-Excel/m-p/86236#M37117 RadoslavHiko 2016-09-09T18:23:00Z