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