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.

Nou pe simpatie:
Ana Maria 25 pe Simpatie

Femeie
24 ani
Bucuresti
cauta Barbat
35 - 68 ani

Mrrrr's Forum (VIEW ONLY)Reguli Inregistrare Login PozeNu sunteti logat. Lista Forumurilor Pe Tematici

Mrrrr's Forum (VIEW ONLY) / Tutoriale si Ghiduri Utile // Tutorials and useful guides /

[EXCEL] TEXTSPLIT in Older Excel Versions

Pagini: 1

Moderat de TRaP, TonyTzu

pus acum 4 luni#1

TRaP
Moderator
Postari: 960

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 4 luni#2

TRaP
Moderator
Postari: 960

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[.!='']"
)

Pagini: 1

Mergi la