L
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
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