cell reference question

  • Thread starter Thread starter Michael J. Malinsky
  • Start date Start date
M

Michael J. Malinsky

I swear I did this once, but I can't find where I did it and I can't
remember how I did it (if I did)

Say in cell A1 I have the formula:

=B1

Is there something I can put together in cell C1 that will refer to cell A1
and return the text:

=B1

I'm trying to do something that will concatenate a description with the
location of the data (in C1, for example) without having to move to the cell
that actually contains the formula (A1). It needs to be dynamic because
rows and/or columns can be added/deleted from the worksheet. There's
probably a way I can do this in VBA, but I'm trying to avoid that for
various reasons.

Any help is greatly appreciated (and will stop me from thinking I'm going
nuts...lol).

TIA,
Mike.
 
Hi
one way: use the following UDF:

Function ret_formula(rng As Range) As String
ret_formula = CStr(rng.Formula)
End Function

Use it in C1 as follows
=ret_formula(A1)
 
Thanks, but I'm trying to avoid using UDFs and VBA. This particular
situation does not lend itself to that due to other software involved that
is using Excel. I'd rather utilize a worksheet function if possible.

Thanks.
 
Try ="test"&text(A1,"##0")
I got this from the news letter don't recall when
Esau
 
Back
Top