A cell contains “North,Room 2”, but you need the area and room in separate columns. Excel’s Text to Columns wizard can split the text. Before finishing, check both the separator and the destination; a plausible preview does not establish that the output cells are safe to use.
Choose only the separator you need
Work in a saved copy of the workbook. In the desktop wizard documented for Microsoft 365 and Excel 2024, 2021, 2019 and 2016, select the source cells, then Data → Text to Columns → Delimited. Choose the delimiter and inspect Data preview.
For the fictional value above, choose the comma. The space in “Room 2” belongs to the room name, so do not also split on spaces. Verify that the preview has two fields, not three. Inspect a second value too; the first row may not represent the whole selection.
Reserve the whole output area
Suppose A1:A3 contains three sample records and D1:E3 is empty. Choose D1 as Destination for a two-column result. Inspect all six destination cells before Finish, including any formulas or labels you need to preserve. If they are occupied, choose another empty area rather than accepting an overwrite.
After the split, compare all three records with the source: two fields per row, “Room 2” intact, and the original source still available. Save the reviewed copy under a clear name. This example checks a three-record transformation; no real workbook was edited.