In some situation that you may need to edit the formula in batch,
Besides using the replace function, you can use the "formula view"
By pressing "CTRL+`" (Button for ~),
or (Excel before 2007) Tools->Option->View->Windows Option->[Formula]
(Excel 2007) Formula Ribbon-> Formula Auditing->Display formula
You can view and even copy the formula to other application e.g. Notepad/Ultra Editor
No comments:
Post a Comment