如何从Excel中删除包含少于3个字符的单元格?我的工作表中只有一栏 [英] How do I delete a cell from Excel which contains less than 3 characters? I have only one column in sheet

问题描述

Excel文件仅包含城市.我要删除少于三个字符的单元格.

如何从Excel中删除所有少于3个字符的单元格?

解决方案

1. 在excel中时，按 Ctrl + F

2. 单击替换"标签.

3. 在查找内容:"框中，输入??.(您要搜索的单元格中的字符数量)

4. 替换为:"框，将其保留为空.

5. 确保选中匹配整个单元格内容"框.

6. 然后只需单击全部替换按钮

问号代表任何字符，因此，如果您输入四个问号，则只会得到包含四个字符的单元格.当您输入三个问号时，您只会获得带有三个字符的单元格，依此类推.

由于您只想删除少于3个字符的单元格，因此需要执行两次.准时与"??"(对于具有2个字符的单元格)，在查找内容"框中查找，一次单击?"(对于具有1个字符的单元格)在查找内容"框中.我希望这就是您要寻找的.

The Excel file contains only cities. I want to delete the cells which contain less than three characters.

How do I delete all the cells from Excel which contain less than 3 chars?

解决方案

1. When you are in excel press Ctrl+F

2. Click the "Replace" tab.

3. In the box "Find what:" enter ??. (the ammount of characters that are in the cells you're searching for)

4. The box "Replace with:", leave it empty.

5. Make sure you check the box "Match entire cell contents".

6. Then simply click the replace all button

The question mark stands for any character, so if you put in four question marks you will get only the cells with four characters. When you put in three question marks you will only get the cells with three characters and so on.

Since you only want to delete the cells with less then 3 characters you need to do this twice. On time with "??" (for cells with 2 characters) in the "Find What" box, and one time with "?" (for cells with 1 character) in the "Find What" box. I hope this is what you're looking for.

这篇关于如何从Excel中删除包含少于3个字符的单元格?我的工作表中只有一栏的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！