View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default turn text into a formula

EditReplace

what: "

with: nothing


Gord Dibben MS Excel MVP

On Thu, 12 Oct 2006 12:19:02 -0700, trav2016
wrote:

I used mid to extract a text sting "=countif(c$3:c$12,$ad1)"
How do I turn this text into a formula (basically removing the parenthesis
around the text) and having a value come form the formula that has then been
entered.
Thanks