Upper text sort excel 1

[leijen]

I have a list of names.
here is an example Mrs Lesley Elizabeth GODDARD
I want the Uppercase last name in a new cell

How can this be done?

Thanks

 

[DaleWatson123321]

Hi leijen,

Here's one method. In this example the column with names is Column A.

1) In B1, enter:
=FIND(" ",A1,1)

2) In C1, enter:
=IF(ISERR(FIND(" ",A1,B1+1)),0,FIND(" ",A1,B1+1))

3) In D1, enter:
=IF(ISERR(FIND(" ",A1,C1+1)),0,FIND(" ",A1,C1+1))

4) In E1, enter:
=IF(ISERR(FIND(" ",A1,D1+1)),0,FIND(" ",A1,D1+1))

5) In F1, enter:
=MAX(B1:E1)

6) In G1, enter:
=MID(A1,F1+1,LEN(A1))

7) Copy the formulas from B1:G1 down for as many rows as required.

8) To convert the formulas to values:
a) Highlight the formulas and copy them.
b) Paste the formulas to the same location by using the menu: Edit - Paste Special - Values.

I hope this helps. Please advise as to how it fits.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[leijen]

Thanks Dale
This did the trick.

Regards

Sam Leijen
New Zealand