I'm am very new to using vba in excel and i'm trying to write a code that splits the names from one cell into 2 cells and leaves out the "," between the names and the middle initial
this is what i have so far but whenever i try to compile it highlight the first number Row = 2 and says "Compile...