Return the words in reverse order

If you want to change the names in a column from "Lastname Firstname" to "Firstname Lastname" you can use the following formula; RIGHT("A1", LEN("A1") - SEARCH(" ", "A1") -1 & " " & LEFT("A1", SEARCH(" ", "A1") -1)


© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top