从段落/文字中获取电话号码 [英] Get phone numbers from paragraph/Text

问题描述

你好朋友，
我有一个Excel文件，它包含一列原始数据，如

名称
地址
座机号码
手机号码
(此数据在一列中，并用行分隔)

我只想从此列表中提取手机号码.

解决方案

没有办法.
您必须在excel中添加额外的列，该列在电话，姓名，地址等行中包含唯一标识，并使其只读并提供过滤器.
U必须告诉用户在输入数据时从过滤器指定唯一身份...

希望对您有所帮助.

浏览此链接，然后尝试.

http://support.microsoft.com/kb/311731 [ 解决方案

There is no way .
U have to add on extra column in excel which contains unique identity in terms of rows like phone,name,address and make it read only and give filter.
U have to tell user to specify that unique identity from filter while entering data...

Hope it helps..

Go through this link and try.

http://support.microsoft.com/kb/311731[^]

if you have any query ,post it..

Excel provides you an ''Text to Column'' option to help this kind of situations, try this by proving line breaks as the delimiter.

这篇关于从段落/文字中获取电话号码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！