@Matthew_Owen How exactly does the Notepad file look like? Perhaps the fields ar not separated by a "regular" space.
You can find out about the separator by splitting the text into its individual characters and the CODE function.
The attached file contains an example. One string has a regular space (character number 32), the other has a line feed (character number 10).
Splitting the text was done in two different ways. One using SEQUENCE (in C1, will work for you if you are on a recent Excel version). Alternatively, the formula in H1 (with helper column in G, and copy down) will work in all versions.
