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
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgJXaAOGXnOwNkr-xG9lw4AdR6VQxPFQKXcYkhaqRcP6mB8AAQp4JkraQvq3-w8TnaSZTludvGgCekM-862JexDqAKg7GeOjz_vy-ro7k3u3wXY95Dm6q9PpqKWdQp7tdDZlUfmAdPzJrYk/s400/20090705.jpg)
No comments:
Post a Comment