Format name into outlook email format

[wonka1234]

For example my name will be John Doe, how can I create a formula to make it  "Doe, John"

[aszacilo]

One solution is to use the parse tool on the name column. Use a space as your delimiter to parse the full name to columns. Next, use a formula tool to create a new column. For the new column you can use this formula:  'Last name" + ", " + "First name" to get Doe, John.