Results 1 to 1 of 1

Thread: Import Converter deletes line feeds automatically

  1. #1
    Acolyte pinarello's Avatar
    Join Date
    Jun 2019
    Location
    Germany
    Posts
    55
    Articles
    0
    Excel Version
    Office 365

    Import Converter deletes line feeds automatically



    Register for a FREE account, and/
    or Log in to avoid these ads!

    After loading a website with Power Query I would have to notice that the import converter deleted line feeds (lf - Chr 10) during loading. This leads to the fact that I have no more possibility to split the text in the corresponding columns correctly.

    However, when I copy individual web pages to the clipboard and paste them into Excel's formula row, I then see (line 33) the line break and can replace it (line 35).

    I have documented an example in the enclosed Excel folder.

    Is there a way to solve this problem ???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •