Excel Help-Copy Certain Numbers

November 23rd, 2018

Hi,
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

Answer #1
try : =IF(ISNUMBER(SEARCH(“077*”,A1)),A1, “Not OK”) , then simply sort the column and you will have all number starting with 077
Answer #2
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.
Answer #3
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
Answer #4
Why don’t you just sort by that column so all the 077’s will be together. Then just copy those numbers
Answer #5
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.

 

| Sitemap |