How to remove line breaks in Excel cells RRS feed

  • Question

  • I tried the tutorial in Power Query 101. The data extracted from the web site has embedded line breaks in the Year column

    After removing the Details tet in the Replaced Value step, there are still embedded line breaks in the cells. How can I remove the embedded line breaks as a step in the query editor?


    • Edited by Hardwire Thursday, April 27, 2017 4:10 AM
    Thursday, April 27, 2017 4:08 AM


  • Probably you are referring to this tutorial?

    I could replicate the issue.

    My suggestion would be to select the column and use Clean (Transform tab - Format - Clean), just after the step in which "Details"  is removed.

    Strange that this is not included in the tutorial, because cleaning text from input is a good practice.

    Good luck with further tutorials.

    Thursday, April 27, 2017 6:52 AM

All replies