Excel Help-Copy Certain Numbers
November 23rd, 2018
Lets assume I have phone numbers list like this:
07721251222
07135235235
07249835353
07789235855
07299583255
07735902355
07724242424
I want to copy every number that starts with “077” to clipboard or txt doc or another column in Excel etc.
Is there any way to do this in Excel?
If not do you know any software that I can use to do this?
Thanks
try : =IF(ISNUMBER(SEARCH(“077*”,A1)),A1, “Not OK”) , then simply sort the column and you will have all number starting with 077
My guess is that right next to the numbers he has the name of each of those phone numbers. Can’t remember though how to link the rows before sorting them out.
try : =IF(ISNUMBER(SEARCH("077*",A1)),A1, "Not OK") , then simply sort the column and you will have all number starting with 077
this doesn’t work. thanks BTW
Why don’t you just sort by that column so all the 077’s will be together. Then just copy those numbers
Why don't you just sort by that column so all the 077's will be together. Then just copy those numbers
Of course. Thank you very much for pointing out the “simple” solution.