Re: Evaluate "nested-merge" function?
- From: Pete_UK <pashurst@xxxxxxxxxxx>
- Date: Fri, 31 Oct 2008 06:37:21 -0700 (PDT)
I think the function you are referring to is CONCATENATE.
To evaluate the composite string you have built up as if it were a
formula, you could use this UDF:
Function Eval(Rng As Range) As Variant
Application.Volatile True
Eval = Evaluate(Rng.Text)
End Function
Then assuming that your formula is in A4, put this in A5:
=Eval(A4)
Hope this helps.
Pete
On Oct 31, 1:16 pm, Mikael Lindqvist
<MikaelLindqv...@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
Hi everyone,
I'm using a swedish version so I don't know the exact name of the function I
used, but it "merged" the values of cell references that I inputed.
A1=Left
A2=B1
A3=4
So, I write the function (translated to english):
=MERGE("=";A1;"(;";A2;";";A3;")")
Which then reads:
=Left(B1;4)
Now, the big question... is it possible to evaluate this function directly?
Alternatively I need to copy / paste value to have it evaluated, but this
feels unnecessary cumbersome.. I'm sure there's a more clever approach - I
just need someone to point it out to me :>
Kindly,
Mikael
Sweden
.
- References:
- Evaluate "nested-merge" function?
- From: Mikael Lindqvist
- Evaluate "nested-merge" function?
- Prev by Date: Evaluate "nested-merge" function?
- Next by Date: Re: I need an Equation in a cell to search a workbook not workshee
- Previous by thread: Evaluate "nested-merge" function?
- Next by thread: Formula assistance - if / then statement
- Index(es):
Relevant Pages
|
