Replace function

  • Thread starter Thread starter chrismania
  • Start date Start date
C

chrismania

Hi guys
How Can I replace
all formules which contain $a$53 to $a$100 for every capital. That
means also $b$53 to $b$100 and so on ?

Thanks
 
Highlight the cells........Edit > Replace > in the "Find What:" window type
$53......in the "Replace with:" window type $100 > Replace all

Just be sure you have a backup file before doing large scale Find and
Replace's......

Vaya con Dios,
Chuck, CABGx3
 
Back
Top