Let me put in my option:
=RIGHT(A1,LEN(A1)-SEARCH(" ",A1,14))&", "&MID(A1,14,SEARCH(" ",A1,14)-14)
So I assume it always starts "Driver Name: " so I know the first name starts at position 14.
The challenge is with people who use a middle name or honorifics.
[TABLE="width: 600"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Driver Name: Donald Williams Jr[/TD]
[TD]Williams Jr, Donald[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]Driver Name: Donald Williams[/TD]
[TD]Williams, Donald[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]Driver Name: Donny Boy Williams[/TD]
[TD]Boy Williams, Donny[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]Driver Name: Mary Lou Williams[/TD]
[TD]Lou Williams, Mary[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]Driver Name: Mr Williams[/TD]
[TD]Williams, Mr[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]Driver Name: Donald Arthur Williams III[/TD]
[TD]Arthur Williams III, Donald[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]Driver Name: Sir Donald Williams, Esq[/TD]
[TD]Donald Williams, Esq, Sir[/TD]
[/TR]
</tbody>[/TABLE]
Sheet3
[TABLE="width: 85%"]
<tbody>[TR]
[TD]
Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH]B1[/TH]
[TD="align: left"]=RIGHT(
A1,LEN(A1)-SEARCH(" ",A1,14))&", "&MID(
A1,14,SEARCH(" ",A1,14)-14)[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]