Professor Excel

Comments 2

  1. Aidan


    I’m getting inconsistent results with this. I have multiple spreadsheets with line breaks. I’ve also created a few with line breaks myself, for testing.

    But the Ctrl+H function only finds some of them. It completely misses others. What might cause this? Could it be that something looks like a line break but is really something else?

    Thanks and regards,

    Aidan Sweeney

    • Henrik Schiffner

      Hi Aidan,

      sometimes people use a lot of space characters in order to achieve line breaks.
      If that’s not the case, can you try to copy the “line breaks” and search/ replace them?

      Best regards,

Leave a comment