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:
runnyroxy la Simpatie.ro
 | Femeie
25 ani
Suceava
cauta Barbat
26 - 57 ani |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 909
|
|
TEXSPLIT does not work in older Excel versions, like 2021 for example.
So while this works for me in 365:
=IFERROR(
TEXTSPLIT(
G103;
;
CHAR(10)
);
"") |
An Excel 2021 could use this instead:
=IFERROR(
FILTERXML(
"<t><s>"&SUBSTITUTE(G103;CHAR(10);"</s><s>")&"</s></t>";
"//s"
);
"") |
|
|
| pus acum 13 zile |
|
|
TRaP
Moderator
Inregistrat: acum 8 ani
Postari: 909
|
|
A FILTERXML adaptation that ignores empty lines - untested:
=FILTERXML(
"<t><s>"&
SUBSTITUTE(
SUBSTITUTE(G103;CHAR(10)&CHAR(10);CHAR(10));
CHAR(10);
"</s><s>")
&"</s></t>";
"//s[.!='']"
) |
|
|
| pus acum 13 zile |
|