Splitting a column divides it into several columns according to a delimiter (comma, space), a number of characters or a position. It is useful for separating a full name, an address or a composite value. You then check the type of the new columns.
Example
Table.SplitColumn(Source, "Nom complet", Splitter.SplitTextByDelimiter(" "), {"Prénom", "Nom"})