Quote:
Originally Posted by jinga
Hi all,
brand new member of the site with a bit of a puzzler. Not sure where to start or indeed if this is the place to ask!!
In a nutshell I have a spreadsheet of data that i need to go through to find data that meets a specific criteria and I am not sure where to start.
Best example i can give is a telephone number.
Rather than search the spreadsheet for a specific number i want to be able to get Excel to show me all instances of an eleven digit number regardless of what the actual number is.
Hopefully that makes sense?
Cheers
D.
|
If column A is where are all the numbers a
=IF(LEN(A2)=11,"Mobile Number","Not Mobile Number")