A room request comes in as South;East;North in one cell. You need one name per row for a sign-off sheet. Use the row delimiter in TEXTSPLIT to keep the order and make the result vertical.
Omit the column delimiter
Put the original text in A2. In B2, with space available below it, enter the formula in an editor that supports TEXTSPLIT:
=TEXTSPLIT(A2,,";")The adjacent commas leave the column delimiter blank. The semicolon in quotes is the delimiter inside the source text. If your spreadsheet uses a different formula-argument separator, keep the quoted delimiter as it appears in the source.

Illustrated split. Leave the column delimiter omitted.
Check the number of rows and look for gaps
South should appear in B2, East in B3 and North in B4. Try South;East and check that B4 is no longer part of the result. Test South;;East if the export can contain empty fields. The default preserves an empty entry. Use TRUE as the fourth argument only if those empty fields can be dropped.

Illustrated edge check. Decide how to handle missing names before ignoring empty results.
Microsoft’s TEXTSPLIT reference, including a row-only example



