Post Author: rfyffe
CA Forum: Formula
Our HR software saves employees names in one field (for example: Doe, John Q). I need to export HR data into an excel spreadsheet, but the first, last and middle initial must be in 3 separate columns. I used the instr function to get the last name, but I cannot figure out how to get the first name and middle initial into their own fields. The format is always last name, first name, but not everyone has a middle initial. Anyone have an idea how to do this?