Thread: How to replace a function with its resulting reference in a formula?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel,microsoft.public.excel.programming,microsoft.public.excel.worksheet.functions
Dmitry Kopnichev Dmitry Kopnichev is offline
external usenet poster
  
Posts: 17
Default How to replace a function with its resulting reference in a formula?
Hello
How to replace a function with its resulting reference in a formula? For
example, How to replace =HLOOKUP(1...)+HLOOKUP(2...) with =b11+z11. I need
to replace in 1000 formulas/cells automatically.


Reply With QuoteReply With Quote