如何从列excel中提取10位数字 [英] how to extract 10 digit number from column excel

问题描述

我有一列包含13位数字的文本。如何保留10位数字并删除所有其他文字？
请帮助我我是新的excel ..
感谢提前

编辑：
单元格格式

  [6/11/2013 3:26:37 PM] 1234503776599，ksdfl 038ddf63Ksdf）
 [6/12/2013 3:26： 37 PM] 0234503664599，ksdfadssdfl 038ddf6dfsd3Ksdf）
 [6/13/2013 3:26:37 PM] 7234503666099，45sdsdfadssdfl 03845ddf6dfsd3Ksdf）
  

这里，第二列我想保留13位数字，删除13位数后的所有文本。

解决方案

数字是否始终在单元格的开头？如果是这样，您可以使用 = LEFT（cell_ref，10）来提取前10个字符，这在这种情况下是数字，并将被电子表格对待。 p>

I have column which consists of text including 13 digit number. How Can I keep 10 digit number and delete all other text? Please help me I am new to excel.. thanks in advance

Edited: Cell Format

[6/11/2013 3:26:37 PM]         1234503776599, ksdfl 038ddf63Ksdf)
[6/12/2013 3:26:37 PM]         0234503664599, ksdfadssdfl 038ddf6dfsd3Ksdf)
[6/13/2013 3:26:37 PM]         7234503666099, 45sdsdfadssdfl 03845ddf6dfsd3Ksdf)

Here, In second column I want to keep 13 digit and delete all text after that 13 digit.

解决方案

Is the number always at the beginning of the cell? If so you can use =LEFT(cell_ref, 10) to extract the first 10 characters, which in this case are numbers and will be treated as such by the spreadsheet.

这篇关于如何从列excel中提取10位数字的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！