Combine UPPER function with another formula

I've looked online, and I'm only seeing instructions on how to capitalize names by using the UPPER function by itself. Is there any way to combine this function with another formula? I'm wanting to change a Last Name, First Name to First Name Last Name, and then by the way, also capitalize the name.  Thanks!