• 办公

    excel单元格内，如何将一个字符替换成换行字符

    2026年1月7日 09:35 /
    在 Excel 中把一个字符替换成换行符，常用批量替换（Ctrl+H+Ctrl+J）、公式替换（SUBSTITUTE+CHAR (10)）两种方法，替换后需开启 “自动换行” 才能正常显示Microsoft Learn。以下是详细操作与常见问题处理：

    方法一：批量替换（Ctrl+H，适合大量数据）

    1. 选中要处理的单元格区域。
    2. 按 Ctrl+H 打开 “查找和替换” 对话框。
    3. 在 “查找内容” 中输入要替换的字符（如逗号、分号、空格等）。
    4. 在 “替换为” 框中按 Ctrl+J（此时框内无可见字符，但已插入换行符）。
    5. 点击 “全部替换”，完成后关闭对话框。
    6. 选中单元格，在 “开始”→“对齐方式” 中点击 “自动换行”，或右键 “设置单元格格式”→“对齐”→勾选 “自动换行”。

    方法二：公式替换（SUBSTITUTE+CHAR (10)，适合保留原数据）

    1. 在空白单元格输入公式：=SUBSTITUTE(原单元格, "要替换的字符", CHAR(10))，例如 =SUBSTITUTE(A1, ",", CHAR(10))Microsoft Learn。
    2. 按 Enter 确认后，下拉填充公式到需要处理的行。
    3. 选中公式结果区域，开启 “自动换行”（步骤同方法一第 6 步）。
    4. 若需将结果转为值：复制公式结果→右键目标区域→“选择性粘贴”→“值”。
    阅读更多
  • 每日完成工作

    Work completed Tuesday, Sunny, January 6, 2026

    2026年1月6日 17:19 /
    1. Finish the document issuance for team evaluation and deputy team leader evaluation.
    2. Carry out the compliance evaluation of the safety assessment norms before the initial operation.
    3. Complete the first draft of the energy conservation management implementation plan for 2026.
    4. Finish the optimization of the output interface for quick transfer.

    【1】Think twice every day (think first about what you did well, think twice about what you did badly, think thrice about what you gained today and plan for tomorrow)：

    Originally, I was planning to set up a convenient transfer system. But after looking at the transfer routes on Gaode Map, I realized they are already quite mature. I’m not sure if I can still apply for it.

    【2】One sentence a day (one hundred words)：

    Love is like the wind, you can’t see it but you can feel it.

    阅读更多
  • 每日完成工作

    Work completed Tuesday, Sunny, January 5, 2026

    2026年1月5日 17:06 /

    Work completed Tuesday, Sunny, January 5, 2025：

    1. Complete the summary of the PPT for the fourth-quarter report.
    2. Prepare the materials for the department-level regular meeting of the technical module.
    3. Conduct a compliance evaluation of the newly issued safety assessment management measures for the initial operation.

    【1】Think twice every day (think first about what you did well, think twice about what you did badly, think thrice about what you gained today and plan for tomorrow)：

    I consulted the application process for a patent today and found that it requires various materials. It seems really complicated.

    【2】One sentence a day (one hundred words)：

    Success is not final, failure is not fatal: it is the courage to continue that counts.

    阅读更多