=SUBSTITUTE(A1, CHAR(13), " " & CHAR(13)) Excel Formula not Working

Ask for Help
11

Try typing a Carriage Return (Enter key) into the ‘Replace This’ parameter.

Then there are a few things you can try in the ‘With This’ parameter:

  • 2 spaces and a carriage return
  • <br>
  • <p>

One of those should work.

3 Likes