https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56567#M10731 I have process where the text file is getting downloaded. I have to convert the text file to excel by delimiting the text having special character. (Copy text file => open excel => paste values => find unique character => split => autofit => Save ) Delimiting code is working properly for special characters tab, comma, semicolon but when the other character is appearing in text like "" | "", the popup message is appearing ""Do you want to replace the contents of the cell"". Need code to disable the popup. Mon, 22 Jan 2018 09:35:00 GMT RuchitaGavali 2018-01-22T09:35:00Z https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56565#M10729 Hello, I want to convert text file to excel, delimiting the special character ( | ). While delimiting excel popup is appearing as "Do you want to replace the contents of the cell". Due this robo is getting stuck. on delimiting. Have also added "wb.Application.AlertBeforeOverwriting = False" into code but still message is appearing. Please advice its urgent. Thank you. Fri, 19 Jan 2018 11:08:00 GMT https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56565#M10729 RuchitaGavali 2018-01-19T11:08:00Z https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56566#M10730 Try converting the text file to CSV ""formatted"",""like"",""this"". Excel should be able to open that straight away. Fri, 19 Jan 2018 14:18:00 GMT https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56566#M10730 John__Carter 2018-01-19T14:18:00Z https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56567#M10731 I have process where the text file is getting downloaded. I have to convert the text file to excel by delimiting the text having special character. (Copy text file => open excel => paste values => find unique character => split => autofit => Save ) Delimiting code is working properly for special characters tab, comma, semicolon but when the other character is appearing in text like "" | "", the popup message is appearing ""Do you want to replace the contents of the cell"". Need code to disable the popup. Mon, 22 Jan 2018 09:35:00 GMT https://community.blueprism.com/t5/Product-Forum/Converting-Text-to-Excel/m-p/56567#M10731 RuchitaGavali 2018-01-22T09:35:00Z