Replace function

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
 
P

Peo Sjoblom

You can do that using the replace from edit>replace, what $A$53, with $A$100
 
C

CLR

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
 
Top