用单元格中的换行符替换逗号 [英] Substitute a comma with a line break in a cell

问题描述

在下面的单元格中，我想获取由逗号分隔的所有内容以换行.我可以使用alt + enter手动添加这些换行符，但是这次我要使其自动化.

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:打开，事件:XXXX站点关闭，受影响的服务:2G，影响:覆盖 在XXXX地区恢复，原因:正在调查，恢复时间:30 分钟，开始时间:14:25:13，结束时间:15:18:03，持续时间:00:52:50，SLA:1 小时.

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.

推荐答案

由于某种原因，以上都不适合我.但是，此DID:

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

1. 选择了我需要替换的单元格范围.
2. 转到主页>查找并添加选择>替换或 Ctrl + H
3. 查找内容:,
4. 替换为: CTRL + SHIFT + J
5. 点击Replace All

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

将 CTRL + SHIFT + J 注册为换行符.

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

这篇关于用单元格中的换行符替换逗号的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！