Try reversing the string first, then using charindex to look for the first space. You should also cater for scenarios where there is no space.
For example:
declare @test varchar(255) = 'Europe - DPS Sweden'
SELECT REVERSE(LEFT(REVERSE(@test), iif(charindex(' ', REVERSE(@test)) = 0, LEN(@test), charindex(' ', REVERSE(@test)) - 1)))
Results
Sweden
Note that this also works if there are no spaces
SET @test = 'nospaces'
SELECT REVERSE(LEFT(REVERSE(@test), iif(charindex(' ', REVERSE(@test)) = 0, LEN(@test), charindex(' ', REVERSE(@test)) - 1)))
Result
nospaces