TEXTSPLIT
Splits text by a given delimiter to an array of multiple cells.
Introduza a fórmula como fórmula de matriz. Suxestión: Introduza a fórmula empregando as teclas Ctrl + Maiús + Intro.
TEXTSPLIT(Text [; Column Delimiter [; Row Delimiter [; Ignore Empty [; Match Mode [; Pad With ]]]]])
Text: (optional) the text to split.
Column Delimiter: (optional) the text to delimit the columns. Multiple delimiters can be supplied.
Row Delimiter: (optional) the text to delimit the rows. Multiple delimiters can be supplied.
Ignore Empty: (optional) set to TRUE to ignore consecutive delimiters otherwise creates an empty cell. The default to FALSE.
Match mode: (optional) set to 1 to perform a case-insensitive match otherwise does a case-sensitive match. The default to 0.
Pad with: (optional) the value with which to pad. The default is #N/A.
Pódese omitir calquera dos argumentos opcionais. Un argumento opcional require que todos os separadores presentes estean presentes.
If cell A1 contains "AA,BB,,CC/DD,EE,FF/GG,HH,II,JJ", then
{=TEXTSPLIT(A1;",";"/";FALSE();1;"@@@")} returns the following array:
|
AA |
BB |
CC |
|
|
DD |
EE |
FF |
@@@ |
|
GG |
HH |
II |
JJ |
COM.MICROSOFT.TEXTSPLIT