Importing txt data from SAP to excel - invisible character #

Hi,

I have an odd issue with txt file from SAP.

The issue happens when a ref key 3 (or I assume any other free text field) includes hash # at the end of the string as attached.

The txt file looks normal and this hash is not visible, but when importing it to excel, either by VBA or manually, it always separates the row by # and moves the rest on the next row.

Has anyone else experienced this and managed to work around it?

Thanks a lot.