Hi guys,

what would be the easiest way to reverse the order of words entered in one cell? If Cell A1 says John Smith (one space in between)- how to get Smith John with a formula?

Thanks!