none
how to get rid of the LINE CHANGE in a worksheet RRS feed

  • Question

  • HI all,

    How to get rid of LINE CHANGE in a worksheet in one shot.  Or how to make them evident. I'm not sure how much the TEXT WRAP feature can help.

    thanks a lot,

    Sheldon

    Thursday, July 9, 2020 3:02 PM

Answers

  • Press Ctrl+H to activate the Replace dialog.

    In the 'Find what' box, press Ctrl+J. This will insert the line break character.

    Leave the 'Replace with' box blank.

    Click 'Replace All'.


    Regards, Hans Vogelaar (https://www.eileenslounge.com)

    Thursday, July 9, 2020 3:10 PM

All replies

  • Press Ctrl+H to activate the Replace dialog.

    In the 'Find what' box, press Ctrl+J. This will insert the line break character.

    Leave the 'Replace with' box blank.

    Click 'Replace All'.


    Regards, Hans Vogelaar (https://www.eileenslounge.com)

    Thursday, July 9, 2020 3:10 PM
  • thank you so much Hans! It works well.

    Sheldon

    Monday, July 13, 2020 11:44 PM