works at Deloitte

How do I remove line breaks within a cell?

2
  1. PwC 1

    Line breaks? You mean like carriage returns within cells? Open find and replace (Ctrl + H). In the “find” field, type Ctrl + J. Leave the “replace” field blank. Then click “replace all”

    2
  2. works at Deloitte
    Author

    Thanks