With data in A (A2 as start) put this in B2 and copy down:

=IF(ISNUMBER(FIND("P O Box",A2)),A2,"")

HTH

"Noncentz303" wrote:

Ok I have a list of addresses as such ...

2424 Midpoint Drive
216 Racquette Dr #7
P O Box 260005
P O Box 260005
2094 N Union Street
8570 Valencia Street

I have been tasked at to find all of the records which contain P O box and
copy them to the adjacent cell on my table. If there a function that handles
this....

BTW thanks for all the help everyone in this forum has been :)