Today I helped a coworker with some MS Excel97 functions to split out a full name in one cell into two separate cells for first and last name. So if cell A1 contains "Doe, John", then cell B1 should display "Doe" and cell C1 should display "John".

Code for cell B1: Last Name
=MID(A1,1,FIND(", ",A1,1)-1)
Code for cell C1: First Name
=MID(A1,FIND(", ",A1,1)+2,LEN(A1))

Too bad Excel doesn't have the perl split function.


-Chris