I have a list in column B that looks like this

Jones Fred
Brown Al
Daniels Bert

what I want to end up with is

JONES
BROWN
DANIELS

so in short I need to extract the first word of the cell and it needs to be
in capital letters.

What is the best way to do this please.


Bob