Skip to Content
0
Former Member
Aug 21, 2007 at 09:27 PM

Formula to split a field.

63 Views

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?