For some reason, none of the above worked for me. This DID however:
- Selected the range of cells I needed to replace.
- Go to Home > Find & Select > Replace or Ctrl + H
- Find what:
,
- Replace with: CTRL + SHIFT + J
- Click
Replace All
Somehow CTRL + SHIFT + J is registered as a linebreak.