如何删除字符“*”在Excel 2010？ [英] How to remove the character "*" in Excel 2010?

问题描述

我在Excel电子表格中有回归表，其中显着性用星号（*）字符表示。这些是附加到单元格中的数字，星号不是恒定的：有时三个，有时两个，有时一个，有时没有。

I have regressions tables in an Excel spreadsheet where the significativity is indicated with stars (*) characters. Those are attached to the number in the cell and the number of stars is not constant: sometimes three, sometimes two, sometimes one and sometimes none.

这些星号使我可以使用单元格中的数字（它目前被理解为由Excel的文本，因为星号的存在。）

I would like to remove those asterisks such that I can use the number in the cell (it is currently understood as text by Excel because of the presence of the asterisk.)

我试过以下：

• 搜索并替换字符*，但由于Excel将其理解为一切，所以我得到了不必要的结果。我也尝试过它的变种：，''。

文本到列：但是由于星号的数目不是常数，它不能工作。

Text to columns: but since the number of asterisks is not constant, it could not work. Besides, I would have to manually do it for an impressive number of columns so this solution is not practicable.

手动删除星星是不可能的，

Manually removing the stars is out of the question, too.

例如，这里是我想要做的：

As an example, here is what I want to do:

A1 = 1 ***

A1=1***

A2 = 2 *

A3 = 3

A4 = sum（A1：A3）

A4=sum(A1:A3)

推荐答案

在Excel中是〜。因此，要查找和替换所有星号，请搜索〜*并替换为空。请移除所有*个字符。

The escape character in Excel is the ~. So, to find and replace all asterisks, search for ~* and replace with nothing. Please see the image in order to remove all * characters.

这篇关于如何删除字符“*”在Excel 2010？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！