View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Al[_4_] Al[_4_] is offline
external usenet poster
 
Posts: 4
Default Convert Text to a Formula

That's a really ingenious trick!
I'm currently seeking for something like that for 2 hours!!!
Thanks a lot!!!



non wrote:

Convert Text to a Formula
02-Jun-08

Copy, then Paste Special: Values will get rid of the apostrophe. Then do a
Find = Replace = (with the equal sign as the Find and the Replace) to force
it into a formula.

"dhstein" wrote:

EggHeadCafe - Software Developer Portal of Choice
A Down and Dirty FileSystem Object Page Counter
http://www.eggheadcafe.com/tutorials...-filesyst.aspx