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+Colorado!Y27+Dallas!Y27+Houston!Y27+SanAntonio!Y27+'Rio
Grande'!Y27+Austin!Y27+Tampa!Y27+Orlando!Y27+Jacksonville!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
Bookmarks