Often - normally when I'm doing something related to email or letter generation - I need an easy way to capture the person's first name to open my communication. Normally I'd use Text-to-Columns, but if the data is poorly structured and there's a mix of FIRST LAST with LAST, FIRST that isn't always an option. I put this formula together to recognize how the name is formatted, and grab the first name accordingly. Hopefully it saves you some time.
=PROPER(IFERROR(IFERROR(LEFT(RIGHT(A1,LEN(A1)-FIND(", ",A1)-1),FIND(" ",RIGHT(A1,LEN(A1)-FIND(", ",A1)-1))-1),RIGHT(A1,LEN(A1)-FIND(", ",A1)-1)),LEFT(A1,FIND(" ",A1&" ")-1)))