Finding a value and copying it to another cell
 

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 :)

Finding a value and copying it to another cell
 

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 :)

Finding a value and copying it to another cell
 

It may not be the prettiest....but...in the cell adjacent to it, you might
use :

=if(left(A1, 7)="P O Box", A1, "")
or
=if(left(A1, 6)="PO Box", A1, "")

Not sure if you have PO box listed as "PO" or "P O" but this will look at
the first 7 (or 6) letters in the column from the left, compare the
text...and then copy the whole text over if it matches.

--
//Jason


"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 :)