Hi there

Please can someone advise how I can grab the right-most text string after a space e.g.

North West London NW - I would want to grab 'NW'.

Many thanks