Converting Text to Excel

[RuchitaGavali]

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.

[John__Carter]

Try converting the text file to CSV ""formatted"",""like"",""this"". Excel should be able to open that straight away.

[RuchitaGavali]

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.