Originally Posted by
reasonableman
The formula result is correct and lists the desired result,the error only occurs when I select OK.
The formula I have been using is such: =MID(A1,FIND(" ",A1, 1)+1,LEN(A1)) & ", " & LEFT(A1,FIND(" ",A1))
The names for the "practice" sheet are from A1 to A7. I am inputting the formula into A1 with the intention of then applying it to the remainder of the column. Each cell has a different name, but all in the same column. The error seems to be the original A1[=MID(A1...] that is according to Excel.
Bookmarks