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.
Substitute a comma avec a line break in a cell
Re: Substitute a comma avec a line break in a cell
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.
- 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.