Replace Cell Address in A Long Formula

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

From time to time, I need to do some change in some very long formula. For example:
=TRIM(IF(ISERROR(FIND(" ",B46,FIND(" ",B46,1)+2)),MID(B46,FIND(" ",B46,1)+1,LEN(B46)),MID(B46,FIND(" ",B46,FIND(" ",B46)+2),LEN(B46))))
I want to replace all the "B46" with "F18". Is there a easier way? Thanks.
 
One quick and dirty way is to Edit>Replace B46 with F18.

HTH
Anders Silven

plumstone said:
From time to time, I need to do some change in some very long formula. For example:
=TRIM(IF(ISERROR(FIND(" ",B46,FIND(" ",B46,1)+2)),MID(B46,FIND("
Click to expand...
",B46,1)+1,LEN(B46)),MID(B46,FIND(" ",B46,FIND(" ",B46)+2),LEN(B46))))
 
Back
Top