Splitting Competition names

Hi There,

I wonder if anyone can help me... I need to split the following line up and make it Caps

Jack Smith v Peter Jones

I want it to look like

SMITH v JONES

I'm working on a competition and have to do hundreds of these.. is this possible in excel ?

I've managed to split the first name by finding " " but I can't manage to get any further..

any help greatly appreciated

regards

Alex