Sorting MCQ questions alphabetically

I see my mistake; the iteration is compounded the data from below. Let's go in a different direction.

This is a little more brute force than is probably necessary but I'm not exactly known for truncation or elegance.

=IF(OR(MID(A1,2,1)=".",NOT(EXACT(PROPER(LEFT(A1,2)),LEFT(A1,2)))),"",A1&
IF(MID(A2,2,1)=".",A2,IF(NOT(EXACT(PROPER(LEFT(A2,2)),LEFT(A2,2))),A2,""))&" "&
IF(MID(A3,2,1)=".",A3,IF(NOT(EXACT(PROPER(LEFT(A3,2)),LEFT(A3,2))),A3,""))&" "&
IF(MID(A4,2,1)=".",A4,IF(NOT(EXACT(PROPER(LEFT(A4,2)),LEFT(A4,2))),A4,""))&" "&
IF(MID(A5,2,1)=".",A5,IF(NOT(EXACT(PROPER(LEFT(A5,2)),LEFT(A5,2))),A5,""))&" "&
IF(MID(A6,2,1)=".",A6,IF(NOT(EXACT(PROPER(LEFT(A6,2)),LEFT(A6,2))),A6,""))&" "&
IF(MID(A7,2,1)=".",A7,IF(NOT(EXACT(PROPER(LEFT(A7,2)),LEFT(A7,2))),A7,""))&" "&
IF(MID(A8,2,1)=".",A8,IF(NOT(EXACT(PROPER(LEFT(A8,2)),LEFT(A8,2))),A8,""))&" "&
IF(MID(A9,2,1)=".",A9,IF(NOT(EXACT(PROPER(LEFT(A9,2)),LEFT(A9,2))),A9,""))&" "&
IF(MID(A10,2,1)=".",A10,IF(NOT(EXACT(PROPER(LEFT(A10,2)),LEFT(A10,2))),A10,""))&" "&
IF(MID(A11,2,1)=".",A11,IF(NOT(EXACT(PROPER(LEFT(A11,2)),LEFT(A11,2))),A11,"")))


Plop that in B1 and copy down. It creates an error on Cushing's Syndrome because it thinks it's the start of a new sentence, but the rest of them it does perfectly. (If you uncapitalize Cushings, it works fine.) Still, with 190,000 rows it's a step in the right direction.

concatenation from hell.xlsx