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 Can you provide some sample names? 

[Hi2023]

AARON J SMITH

A MALIK

AARON JAY SMITH

AARON JAYA HATH SMITH

AARON SMITH

A G SMITH

[binuacs]

@Hi2023 One way of doing this

[Hi2023]

I dont know why but it is not working on each one-it is working on some but not all ????

the names like :

AARON J SMITH

A W SMITH

A SMITH 

the initial is gone / blank

[Hi2023]

I think I just saw the problem -what if I cam just trying to fix it after the formula where it is outputting the first name with middle intial and the last name has already been moved,

like the output are :

AARON J

A W 

AARON BI

AARON JAY

in the first name column only I dont have to worry bout the last name part at this moment

thanks

[binuacs]

@Hi2023 What are the expected output for the below names 

[Hi2023]

middle initial seperated from first name, but if its more than 10 characters(middle name), then to move over to last name 

Input 

A J Smith

output 

first name A  middle name J   last name Smith 

A LOGNMIDDLE NAME SMITH

first name

A

Middle 

blank

last name 

LONGMIDDLENAME

[binuacs]

@Hi2023 how would you split the name AARON JAYA HATH SMITH?

[Hi2023]

hmmm I just checked and I dont have an example like that but its more than 10 characters move all to last name and middle would be blank