ExcelBanter - need some help

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - need some help (https://www.excelbanter.com/excel-worksheet-functions/43398-need-some-help.html)

elz64

need some help

Hi,

How can I find in a whole sheet a phone number (number starts with 01......
or 06..... and is 10 number long) ?

Is there any means without pure programming?

Data comes from a quit destructured sheet exported from another software (no
way to change the export)

thank you

Mangesh Yadav

check response in .programming

Mangesh

"elz64" wrote in message
...
Hi,

How can I find in a whole sheet a phone number (number starts with
01......
or 06..... and is 10 number long) ?

Is there any means without pure programming?

Data comes from a quit destructured sheet exported from another software
(no
way to change the export)

thank you

All times are GMT +1. The time now is 07:01 PM.