create function put date value in written language to avoid maximum number of lines in formula

[littlepete]

hello all

my formula to represent all data in my address list, has reached the maximum of 8192 ...
i would like to replace the normal formula with a short function to reduce that number...
Is it possible to make something like this : a function "txt" to transform the data to written tekst
(25/12/2020 => friday, 25 december 2020)
in the formula it would look like :
TEKST(Q5;"dddd d mmmm jjjj") => txt(q5)

thanks for your advice all !!!

 

[littlepete]

How are you seeing more characters? What you describe is exactly what the LAMBDA is for. Define a name called txt using your LAMBDA formula, then use txt(q5) in your formulas.

that would be great ! but how do i do that? where do i write what ? ... i have no idea... (sorry) ...

 

[RoryA]

Step 3 in the article I linked to.

 

[littlepete]

Step 3 in the article I linked to.

good morning
and thank you for all the help !!!

i now understand the putting of the formula in the named ranges list,
but still my formula is not working, i have put

=lambda(x; TEKST(q5, "ddddd mmm jjjj"),x)

in my named range and named it dx ... what's wrong? how can he know which column to use to form the correct date?

 

[RoryA]

The formula in your defined name dx should just be:

=lambda(x; TEKST(x; "ddddd mmm jjjj"))

then you simply use

=dx(q5)

in your formula in the worksheet.

 

[littlepete]

The formula in your defined name dx should just be:

=lambda(x; TEKST(x; "ddddd mmm jjjj"))

then you simply use

=dx(q5)

in your formula in the worksheet.

indeed! that is what i would like, but my formula in the named range always says there is name problem,
in the named ranges the dx is accepted but in my cel " =dx(q5) " gives me name error...

btw : thank you for helping so fast each time !!!

 

[RoryA]

OK - do you actually have the LAMBDA function? I notice it wasn't in capitals in your formula string.

 

[littlepete]

OK - do you actually have the LAMBDA function? I notice it wasn't in capitals

well,
i do research too, and all i read is that until 2019 (!!!) only office insiders can use it, later all office 365 which i have...
i send you printscreen of my named ranges maybe you see if i can use it or not... is there a way to tell for sure if it's available?

 

[littlepete]

well,
i do research too, and all i read is that until 2019 (!!!) only office insiders can use it, later all office 365 which i have...
i send you printscreen of my named ranges maybe you see if i can use it or not... is there a way to tell for sure if it's available?

MREXCEL refuses my picture dammit why are they doing so difficult over a picture ? sorry i cannot send it

 

[RoryA]

If you type =LA in a cell, do you see LAMBDA appear in the function list?

 

[RoryA]

I forgot to mention - there must be a better way than anything involving a formula of over 8,000 characters...