pulling out data

[librarynerd]

ok guys i need help. i have a list like this that i copy into excel:
address 1:
phone: 555 555 5555
address 2:
phone: 555 555 5555
address 3:
none

address 1:
phone: 555 555 5555
address 2:
none
address 3:
none

this list goes on for pages and i recieve one every day that i mus
sort. i need to come up with just the address 1 phone numbers in
list like so:

555 555 5555
555 555 5555
555 555 5555

i managed to get them all on their own page by doing a search fo
"phone:" and copying the search all list and replacing "phone:" wit
nothing. the only problem is it returns the address 2 phone numbers a
well. so i've been sitting in front of the computer forever and can
figure it out.
can anyone help me? i appreciate i

 

[CarlosAntenna]

1) Try this in cell B2 then copy down the column.
=IF(RIGHT(A1,2)="1:",RIGHT(A2,12),"")

2) data - filter - autofilter on column B for non-blanks
3) copy - paste special - values

 

[librarynerd]

thanks a lot! it worked out great