I have tried using the following formula:
Trim(Left([Cleaned Name],InStr([Cleaned Name]," ")))
to get just the first name from a first name field that may or may not have a middle initial or middle name. However, the resulting output is the first name only if there was a middle name or middle initial. However, the first name field is blank if there was not middle name/initial.
Crystal Janice returns Crystal
Crystal J returns Crystal
Crystal doe not return anything