首页 > 软件教程 >Excel如何每隔几位给一串数字加符号-excel怎样在一串数字中每隔几位添加符号

Excel如何每隔几位给一串数字加符号-excel怎样在一串数字中每隔几位添加符号

来源：互联网 2026-04-01 21:52:32

告别杂乱数字：一个公式让Excel数据清晰可读面对Excel中的长串数字，如何才能快速提取关键信息？本文将介绍一个高效技巧，帮助你轻松为数字添加间隔符号，使数据结构一目了然，提升数据处理效率。一、准备工作：确保数据规范录入在开始操作前，请确认你的数据已完整录入Excel表格。我们以数字“123

告别杂乱数字：一个公式让Excel数据清晰可读

面对Excel中的长串数字，如何才能快速提取关键信息？本文将介绍一个高效技巧，帮助你轻松为数字添加间隔符号，使数据结构一目了然，提升数据处理效率。

一、准备工作：确保数据规范录入

在开始操作前，请确认你的数据已完整录入Excel表格。我们以数字“12345678901234567890”为例进行演示。

二、核心操作：使用公式添加分隔符

Excel如何每隔几位给一串数字加符号-excel怎样在一串数字中每隔几位添加符号

关键在于确定分隔符的插入位置。以每隔三位添加一个逗号为例，我们可以通过Excel公式轻松实现。

1. 确定分隔符添加位置

在一个空白单元格中输入以下公式：

=LEFT(A1,3)&","&MID(A1,4,3)&","&MID(A1,7,3)&","&MID(A1,10,3)&","&MID(A1,13,3)&","&MID(A1,16,3)&","&MID(A1,19,3)&","&MID(A1,22,3)&","&MID(A1,25,3)&","&MID(A1,28,3)&","&MID(A1,31,3)&","&MID(A1,34,3)&","&MID(A1,37,3)&","&MID(A1,40,3)&","&MID(A1,43,3)&","&MID(A1,46,3)&","&MID(A1,49,3)&","&MID(A1,52,3)&","&MID(A1,55,3)&","&MID(A1,58,3)&","&MID(A1,61,3)&","&MID(A1,64,3)&","&MID(A1,67,3)&","&MID(A1,70,3)&","&MID(A1,73,3)&","&MID(A1,76,3)&","&MID(A1,79,3)&","&MID(A1,82,3)&","&MID(A1,85,3)&","&MID(A1,88,3)&","&MID(A1,91,3)&","&MID(A1,94,3)&","&MID(A1,97,3)&","&MID(A1,100,3)&","&MID(A1,103,3)&","&MID(A1,106,3)&","&MID(A1,109,3)&","&MID(A1,112,3)&","&MID(A1,115,3)&","&MID(A1,118,3)&","&MID(A1,121,3)&","&MID(A1,124,3)&","&MID(A1,127,3)&","&MID(A1,130,3)&","&MID(A1,133,3)&","&MID(A1,136,3)&","&MID(A1,139,3)&","&MID(A1,142,3)&","&MID(A1,145,3)&","&MID(A1,148,3)&","&MID(A1,151,3)&","&MID(A1,154,3)&","&MID(A1,157,3)&","&MID(A1,160,3)&","&MID(A,163,3)&","&MID(A1,166,3)&","&MID(A1,169,3)&","&MID(A1,172,3)&","&MID(A1,175,3)&","&MID(A1,178,3)&","&MID(A1,181,3)&","&MID(A1,184,3)&","&MID(A1,187,3)&","&MID(A1,190,3)&","&MID(A1,193,3)&","&MID(A1,196,3)&","&MID(A1,199,3)&","&MID(A1,202,3)&","&MID(A1,205,3)&","&MID(A1,208,3)&","&MID(A1,211,3)&","&MID(A1,214,3)&","&MID(A1,217,3)&","&MID(A1,220,3)&","&MID(A1,223,3)&","&MID(A1,226,3)&","&MID(A1,229,3)&","&MID(A1,232,3)&","&MID(A1,235,3)&","&MID(A1,238,3)&","&MID(A1,241,3)&","&MID(A1,244,3)&","&MID(A1,247,3)&","&MID(A,250,3)&","&MID(A1,253,3)&","&MID(A1,256,,)

公式中的A1是原始数据所在单元格，请根据你的实际数据位置调整。其逻辑是先用LEFT函数提取前三位，再通过多个MID函数依次截取后续每三位数字，最后用“&”符号连接所有片段与逗号。

2. 快速填充应用公式

输入公式后按回车键，格式化结果将立即显示。然后将鼠标移至单元格右下角，当光标变为黑色十字时，按住左键向下拖动，即可快速为整列数据应用此格式。