Extract Value from Field

[Harvey85]

Hi, I have a question. I have a field called Season where I need to keep the text before the numbers at the end (2123, 2223, etc., in the future new numbers of these characteristics may appear, always with 4 numbers at the end).

And the expected output is in the second column. How can I get it? Thank you!!

Season	Expected Output
Abc 2123	Abc
Def 2123	Def
Abc 2223	Abc
Def 2223	Def
Abc 2 2123	Abc 2
Def 2 2223	Def 2
Ghi 1 2324	Ghi 1
Ghi 2 2425	Ghi 2

[HotChilli · Accepted solution]

There are lots of ways in power query to do this.

Example-> Split Column by delimiter (using 'space' as far right as possible)