excel 提取符号前数字_在Excel中摆脱数字符号

excel 提取符号前数字

In your early days of working in Excel, you probably saw the occasional cell full of number signs (you might call them pound signs or hash marks). Here's what you can do to get rid of number signs in Excel.

在使用Excel的早期，您可能偶尔会看到充满数字符号的单元格(您可以称其为井号或井号)。 这是您可以用来消除Excel中数字符号的方法。

Excel中的数字符号 (Number Signs in Excel)

Usually, you'll see cells full of number signs if the column is too narrow to show the full number. It could be misleading if Excel displayed part of a number, so number signs are displayed instead, to alert you to the problem.

通常，如果列太窄而无法显示完整数字，则会看到充满数字符号的单元格。 如果Excel显示的是数字的一部分，则可能会产生误导，因此将显示数字符号，以提醒您该问题。

加宽栏 (Widen the Column)

To fix that problem, widen column C, so there is room for the full number. The quickest way to make the column the correct width is to double-click the line between the headings for columns C and D.

要解决该问题，请加宽C列，以便有足够的空间容纳完整的数字。 使列正确宽度的最快方法是双击列C和D的标题之间的线。

文本单元格充满数字符号 (Text Cells Filled With Number Signs)

What if the column is wide, and the cell contains text, not a number – and it’s full of number signs?

如果列很宽，并且单元格包含文本而不是数字，并且充满了数字符号，该怎么办？

In the screen shot below, cell B2 is selected. In the formula bar, you can see the text from cell B2, and the letters are displayed correctly there.

在下面的屏幕快照中，选择了单元格B2。 在编辑栏中，您可以看到来自单元格B2的文本，并且字母在此处正确显示。

However, instead of showing the text, cell B2 is filled with number signs, in a single row at the top of the cell.

但是，不显示文本，而是在单元格B2的顶部单行中用数字符号填充。

• Cell B2 is set for Wrap Text, but the number signs are not wrapping.
  单元格B2设置为自动换行，但数字符号不自动换行。
• Cell B2 is formatted as Text, instead of Number or General.
  单元格B2的格式为文本，而不是数字或常规。

较宽的列无济于事 (Wider Column Doesn't Help)

There is a lot of text in that cell, but Excel should be able to handle up to 32,000 characters. In cell A2, there is a LEN formula: =LEN(B2)

该单元格中有很多文本，但是Excel应该能够处理多达32,000个字符。 在单元格A2中，有一个LEN公式： = LEN(B2)

The result of that formula shows that there are 1100 characters in cell B2. That is well under the Excel limit.

该公式的结果表明，单元格B2中有1100个字符。 这远低于Excel的限制。

In this case, widening the column doesn’t fix the problem – you’ll just end up with a wider column of number signs.

在这种情况下，加宽列并不能解决问题–您最终只会获得更宽的数字符号列。

修复带有数字符号的文本单元格 (Fix Text Cells With Number Signs)

In this case, the problem is the cell's Number format -- it is set as Text.

在这种情况下，问题是单元格的数字格式-设置为文本。

To fix text cells that are showing number signs:

要修复显示数字符号的文本单元格，请执行以下操作：

• Set the cell format to General, instead of Text.

  将单元格格式设置为General ，而不是Text。

It’s a strange solution, because Text seems like the logical choice, when formatting a cell that contains text.

这是一个奇怪的解决方案，因为在格式化包含文本的单元格时，文本似乎是逻辑选择。

Here is the same cell, with General format.

这是相同的单元格，具有常规格式。

The good news is that this problem seems to be fixed in Excel 2010.

好消息是，此问题似乎已在Excel 2010中解决。

翻译自: https://contexturesblog.com/archives/2011/06/15/get-rid-of-number-signs-in-excel/

excel 提取符号前数字