Mrrrr's Forum (VIEW ONLY)
Un forum care ofera solutii pentru unele probleme legate in general de PC. Pe langa solutii, aici puteti gasi si alte lucruri interesante // A forum that offers solutions to some PC related issues. Besides these, here you can find more interesting stuff.
|
Lista Forumurilor Pe Tematici
|
Mrrrr's Forum (VIEW ONLY) | Reguli | Inregistrare | Login
POZE MRRRR'S FORUM (VIEW ONLY)
Nu sunteti logat.
|
Nou pe simpatie:
Anne98 din Buzau
 | Femeie
25 ani
Buzau
cauta Barbat
27 - 52 ani |
|
Mrrrr
AdMiN
 Inregistrat: acum 18 ani
Postari: 2308
|
|
REVERSE TEXT - APPLE becomes ELPPA
Usage:
=REVERSE(txt)
Lambda to add to Name Manager:
=LAMBDA(txt;
TEXTJOIN("";; MID(txt; SEQUENCE(LEN(txt);;LEN(txt);-1);1))
) |
The one below is a 3D mirroring LAMBDA and works for:
- 1 cell - reversing its contents
John becomes nhoJ
- 1 row of cells or 1 column of cells
0 1 2 3 becomes 3 2 1 0
- >1 rows of cells and/or >1 columns of cells
1 2 3
4 5 6
7 8 9
becomes
9 8 7
6 5 4
3 2 1
=LAMBDA(rng;
LET(
rw; ROWS(rng);
col; COLUMNS(rng);
IFS(
AND(rw=1; col=1); TEXTJOIN("";; MID(rng; SEQUENCE(LEN(rng);;LEN(rng);-1); 1));
OR(rw>1; col>1); MAKEARRAY(ROWS(rng);COLUMNS(rng);LAMBDA(rw;col; INDEX(rng; ROWS(rng)-rw+1; COLUMNS(rng)-col+1)))
)
)
) |
Partially done with Gemini (MAKEARRAY)
_______________________________________
|
|
| pus acum 8 zile |
|