I have very little knowledge of VB. I am trying to write a Macro that will
change the formating of names in a particular column.

This is the data currently:

Last, first initial (ex Trolian, Jason A - or - Trolian, Jason Alan)

The examples show that not all names are the same and in some cases there is
no middle initial or middle name.

The end result that I am trying to reach is 3 columns "First" "Middle" "Last"

If anyone can help we with this it would be greatly appreciated. In the
past I would convert to CSV file and use the comma in the name as a
delimitor. With small amounts of records this is ok but for my purpose now I
will be modifying 17,000 records.

Thank you in advance