I have a column (A) that contains a formula and displays the value
I would like to put in Column B a link to that formula, BUT there the formula should be displayed, and not the value.
Any ideas? Using "show formula" in Tools -> Options is not helpful, as I do not want to to display the formula in column A.
Thanks
One way might be to copy the entire formula into Column B.
Then Find/Replace with column B selected
Find What:=Replace with:= leave empty=
Replace all
Hope this helps.
If you need any more information, please feel free to ask.
However, if this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody! ....
Also
If you are satisfied by any members response to your problem please consider using the small Star icon botom left of thier post to show your appreciation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks