Excel 2007 : What would I need to do for a multiple find & replace?

[domerdel]

I have general fundemental knowledge of MS Excel, but I have a task on my hands where I want to take it to the next level... I'm not sure if this is an Logical "IF" statement, but I was a bit lost when I saw that screen... Here's what I want to do

Column A (Address) = PO BOX 2534
Column B (City) = Richmond
Column C (State) = CA
Column D (Zip) = 94801

IF Column A = PO BOX* (* notes multiple records with unique PO BOX #'s; some PO BOX's are out of state)

CHANGE ALL TO:

Column A = HOMELESS
Column B = San Francisco
Column C = CA
Column D = 94109-0000

[DGagnon]

i notice in thise case i noticed the data does not match (City, State, ZIP) would all cases be the same and defaulting to this address?

[domerdel]

initially, all original data will have unique PO BOX , City, State, and ZIP... by changing Column A to HOMELESS is creating a generic client (for reporting purposes), therefore yes, the end result would give that generic client the same city,state, zip

[DGagnon]

you could create a second set of data and use that for reporting porposes, you could create it in Column F to I as follows
Col F =IF(ISNUMBER(FIND("PO BOX",$A1)),"HOMELESS",A1)
Col G =IF(ISNUMBER(FIND("PO BOX",$A1)),"San Francisco",B1)
Col H =IF(ISNUMBER(FIND("PO BOX",$A1)),"CA",C1)
Col I =IF(ISNUMBER(FIND("PO BOX",$A1)),"94109-0000",D1)

[domerdel]

you could create a second set of data and use that for reporting porposes, you could create it in Column F to I as follows
Col F =IF(ISNUMBER(FIND("PO BOX",$A1)),"HOMELESS",A1)
Col G =IF(ISNUMBER(FIND("PO BOX",$A1)),"San Francisco",B1)
Col H =IF(ISNUMBER(FIND("PO BOX",$A1)),"CA",C1)
Col I =IF(ISNUMBER(FIND("PO BOX",$A1)),"94109-0000",D1)

Definitely a different approach, but it solved it for me.. a big THANK YOU!!