Thread: The result of a formula referring to a cell with formula as text?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default The result of a formula referring to a cell with formula as text?
Cell A1 content is "=B2".
--If you mean =B2 as text try the below formula

=INDIRECT(MID(A1,2,LEN(A1)))

--If you mean formula =B2
=A1


If this post helps click Yes
---------------
Jacob Skaria


"JCC" wrote:

Cell A1 content is "=B2". I want to reference A1 and get the contents of B2.
Reply With QuoteReply With Quote