You can handle multiple spaces by using the TRIM function, which removes extra spaces. You can apply it in your formula like this: =LEFT(TRIM(A2), FIND(' ', TRIM(A2)) - 1) & ', ' & MID(TRIM(A2), FIND(' ', TRIM(A2)) + 1, LEN(TRIM(A2))).