last, first to first last
I want to flip a column which will be last, first names and return first last.
So Doe, John becomes John Doe
I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is not helpful.
Last Name Formula:
=LEFT(NAME31, FIND(",", NAME31) - 1)
First Name Formula:
=RIGHT(NAME34, LEN(NAME34) - FIND(",", NAME34))