My primary field is an employee’s full name in this format: Last, First. The catch is that some employees have a middle initial or a middle name, so it looks like this: Last, First Middle.I want to create two separate columns that separately extract the last name and the first name. I want the separate first name column to include the middle name/initial (if they have one).I’ve been able to create the last name field with this formula: LEFT({Person Name}, (FIND(",", {Person Name}, 1)-1))However, when I use that same formula for the first name field except with the RIGHT function it doesn’t pull out the first name correctly for everyone. RIGHT({Person Name}, (FIND(",", {Person Name}, 1)-1))Any ideas?Solved it: SUBSTITUTE( {Person Name}, LEFT( {Person Name}, FIND( ",", {Person Name} ) + 1 ), "" )
