Access search text string for char, then extract all to right?

[CVBetty]

My imported string looks like this

ACH SOC SEC 310*First Last
I want to access to find the * in the string then extract First Last

 

[Jerry Whittle]

In a query:

FirstLast: Mid([FieldName],Instr([FieldName],"*")+1)

I'd recommend this as the first step. If you want to further split first and
last, there could be problems such as names like Greg von Leghman or Mary Ann
Day.