Is there a way I can select the last part of a string after a space?
e.g. I want to get all the last words from the first line of address. So if it was 1 Smith Close, I just want the word 'Close'.
I've tried using the RIGHT function, but as all the words are different lengths, that isn't very helpfull.
Thank you
e.g. I want to get all the last words from the first line of address. So if it was 1 Smith Close, I just want the word 'Close'.
I've tried using the RIGHT function, but as all the words are different lengths, that isn't very helpfull.
Thank you