Downloading data that has character |

[texasguy66]

Hello, I am downloading data from SAP using a macro in a .txt format. The issue I am having is that when the macro opens the .txt file and saving in an excel format, it splits any cell with | into two separate cells. This does not happen too often, but when it does it causes issues. Also I tried adding the code to change "|" to "" but it did not work.

Has anyone had this happen to them, and how were you able to correct the issue? Thanks.

 

[rlv01]

Can you post your code showing how it opens the text file and how gets the data into the worksheet cells?



How to post your code using code tags:

How to Post Your VBA Code

Post your VBA code.

www.mrexcel.com

 

[Jeffrey Mahoney]

You can open a TXT file in Excel and specify how it parses the data. Ctrl-O, then in the filename enter *.txt and press enter, choose the file. Choose delimited in the wizard. On the next screen choose which delimiter to use. If you record that, you can paste it into your current code