Parsing a name column from first middle last

[Hi2023]

Hi, 

I am working on taking over someones workflow but I havent had much practice with name parsing. The change is that the middle name should be in its own column not with the first name column anymore. The formula is listed below. I am trying to research this but its last minute urgent item so any help wpuld be appreciated and maybe help solve this faster,

thanks

if [ID CODES] != 'FTH'
then
Left([PAYEE NAME],FindString([PAYEE NAME], [OWNER-LAST-NAME])-1)
else null()
endif

I think after this formula is what is seperating this .

[binuacs]

@Hi2023 the above example was provided by you

AARON J SMITH

A MALIK

AARON JAY SMITH

AARON JAYA HATH SMITH

AARON SMITH

A G SMITH

Do you want JAYA HATH SMITH should be in last name?

[Hi2023]

Yes, it was but it an error. If you can just omit that name completely.

[Hi2023]

So, would the formula be the same?

[Hi2023]

Hi, 

so it is somewhat working but its omiting parts of the name.

One name is BETTY B IGUIRRE BANCHEZ VE LETON

the output is 

first name BETTY

middle B IGUIRRE

last name VE

its missing BANCHEZ and LETON 

I also changed the middle name to 10 characters bc that is the character limit for middle name only. where is the BANCHEZ and LETON going? I want it all pushed out after it reaches 10 characters in middle name section to go to LAST NAME.

thanks