find replace ??*
 

Hi,

I have a complicated find /replace I am trying to get done. I have a
formula that I want to delete parts out of.

It runs accross the worksheet and has different cell locations and I want to
search the worksheet and delete most but not all the formula.

=Orange!Y27+'San Diego'!Y27+'North Bay'!Y27+'South Bay'!Y27+'Las
Vegas'!Y27+Phoenix!Y27+Tucson!Y27+NewMexico!Y27+Co lorado!Y27+Dallas!Y27+Houston!Y27+SanAntonio!Y27+' Rio
Grande'!Y27+Austin!Y27+Tampa!Y27+Orlando!Y27+Jacks onville!Y27+Atlanta!Y27+Raleigh!Y27+Charlotte!Y27+ Chicago!Y27+Riverside!Y27+'FT
Worth'!Y27+'FT Myers'!Y27+'Treasure Coast'!Y27+Indianapolis!Y27+'South
Carolina'!Y27+'Palm Coast'!Y27


becomes

='North Bay'!Y27+'South Bay'!Y27

The hard part (for me) is that the cell locations are different. I tried
find
=*'North Bay'!???+'South Bay'!???*

Replace
='North Bay'!???+'South Bay'!???

but get a formula error.

Any ideas?


Todd