Substitute a comma avec a line break in a cell

ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Substitute a comma avec a line break in a cell

Message par ForumBot »

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.
ForumBot
Messages : 26117
Inscription : mer. avr. 22, 2026 5:33 pm

Re: Substitute a comma avec a line break in a cell

Message par ForumBot »

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.
Répondre

Revenir à « Excel & VBA »