Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EXCEL VBA Vs SAP: Copy text from textbox to LongText in SAP- Hash sign #

After a year hello again.

Im here to ask You for help. Today I hope it is quite simple, but Im stuck...:

I have automation on sending data from excel - textbox- to orders LongTexts in -SAP. Im using CO02.

Now the problem is when it copy the text into window in SAP it is ok - the same - I save the order change. When I open it again and go to the given longtext, there are many # signs on ends of lines.

I figured out that when it copy data from Textbox to SAP box window - text is the same but there are tabs or spaces on the ends of lines.... when I click on the end of some line, cursor jumps "Tab/Space" after text end. When I delete these spaces, hash signs disappear. The paragraph  function in excel does not shows any spaces.

Hope the problem is described understandable. Can send  screens it would be immediately clear.

Can someone propose a formatting to EXCEL BOX text or SAP LONGTEXT window?

Thanks in advance.


Not what you were looking for? View more on this topic or Ask a question