Change how name is displayed in a cell

[acct-guy]

I have a cell with values like: Smith, John A.

How can I change them to read: JOHN SMITH

Thanks!

[Glenn Kennedy]

I think that you should give us more examples of your data. Can you have

Smith John A.
Smith III, John A.
Smith, J.
etc....

[Neil_]

part way there..
=UPPER(RIGHT(A1,LEN(A1) -FIND(",",A1))&" " &LEFT(A1,FIND(",",A1)-1))

will have to think about the initial

[acct-guy]

Let's change the question. I now have values in a first name column and a last name column. How can I combine the two columns?

I think that you should give us more examples of your data. Can you have

Smith John A.
Smith III, John A.
Smith, J.
etc....

[Neil_]

=upper(A1 & " " & B1)

got the initial, lol

=REPLACE(UPPER(RIGHT(A1,LEN(A1) -FIND(",",A1))&" " &LEFT(A1,FIND(",",A1)-1)),FIND(".",UPPER(RIGHT(A1,LEN(A1) -FIND(",",A1))&" " &LEFT(A1,FIND(",",A1)-1)))-1,3,"")

[Glenn Kennedy]

BtW, this will do your example:

=UPPER(TRIM(LEFT(SUBSTITUTE(MID(A1,FIND(" ",A1)+1,255)," ",REPT(" ",500)),500))&" "&SUBSTITUTE(A1,MID(A1,FIND(" ",A1)-1,255),""))