Extract 1st word and in capitals

[Robert Gillard]

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

 

[Frank Kabel]

Hi Robert
try
=UPPER(LEFT(A1,FIND(" ",A1)-1))

Frank

 

[Carlos]

try in C1 if Jones ... in B1

=UPPER(LEFT(B1;FIND(" ";B1) or

to be sure with space char

UPPER(LEFT(TRIM(B1);FIND(" ";TRIM(B1))

 

[Robert Gillard]

Perfect thanks Frank

Bob

Hi Robert
try
=UPPER(LEFT(A1,FIND(" ",A1)-1))

Frank