Separating First and Last Names from 1 Cell into 2 Cells

T

thad

Hi All,

I have a list of names in an Excel Spreadsheet listed like
so:

Warner, Kurt
Faulk, Marshall

How would I use a formula or VBA to split the players
first name into one cell and their last name into another
cell.
 
Top