Explain
In the above trick, we used Wildcard to represent the characters. Wildcard includes a ? and * . Sign ? represents any one character. The * sign represents any number of characters. Specifically in the above case:
() : Actual parentheses are not wildcards. They work to divide the sample phrase into logical strings.
<> : The curly brackets work to mark the beginning and end of a word or phrase.
* : Wildcard replaces any number of characters, here is Full Name.
: Seal the backslash with the numerals representing the sequence of characters in angle brackets above.
Thus, Find What box divides the names into two separate strings. Replace With cell proceeds to replace the first character string with the second string and vice versa.
With Wildcard tricks, just be a little flexible, you can completely position the words in the column or list as you want, not simply reversing the position of First and Last names.