excel - Substitute a comma with a line break in a cell

Question

In the cell below, I want to get whatever is separated by a comma to come to a new line. I can add these line breaks manually with alt+enter, but this time I want to automate it.

BCM:Open,Event:Site XXXX is down,Service Affected :2G,Impact :Coverage Restored at XXXX Area,Reason:Under Investigation,Recovery Time :30 Minutes,Start time:14:25:13,End Time:15:18:03,Duration:00:52:50,SLA:1 Hour.

Answer 1

For some reason, none of the above worked for me. This DID however:

1. Selected the range of cells I needed to replace.
2. Go to Home > Find & Select > Replace or Ctrl + H
3. Find what: ,
4. Replace with: CTRL + SHIFT + J
5. Click Replace All

Somehow CTRL + SHIFT + J is registered as a linebreak.