How do I remove all but the first 3 characters in a cell in Excel 2010? I have a column of data that I need to delete everything, which can be 6 more characters up to 30 more characters, except the first 3 characters. None of the characters are identical so Find & Replace won't work.
如何删除Excel 2010中单元格中除前3个字符之外的所有字符?我有一列数据，我需要删除所有东西，除了前三个字符外，最多可以增加6个字符，最多30个字符。所有的字符都不相同，所以Find & Replace将不起作用。
1 个解决方案
#1
9
Put this in B1 and copy it down. I am assuming that the data is in Col A.
把它写在B1上，然后复制下来。我假设数据在Col A中。
=LEFT(A1,3)
#1
9
Put this in B1 and copy it down. I am assuming that the data is in Col A.
把它写在B1上，然后复制下来。我假设数据在Col A中。
=LEFT(A1,3)