• 每日完成工作

    Work completed Wednesday, Sunny, January 7, 2026

    1. Host the shift handover meeting and summarize the meeting minutes.
    2. Complete the submission of metrological tools for inspection in January and retrieve the metrological tools sent for inspection last month.
    3. Conduct compliance evaluations.
    4. Research transfer routes and present them in the form of a route map.

    【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):

    It’s really too difficult to use the map to show the locations of all the stations in the railway network. After spending a long time on it, we still haven’t found a solution.

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

    Confidence is contagious. So is a lack of confidence.

  • 办公

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

    在 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. 若需将结果转为值:复制公式结果→右键目标区域→“选择性粘贴”→“值”。