Help sorting MCQ questions alphabetically

[kokoman789]

I have a text file with MCQ's. after importing it every line got a separate cell
The questions are not numbered and do not have any spaces between them.

Some have ABCD. some have ABCD E as answers. As you see some questions have multiple lines (sometimes even 4 lines).. same holds for answers. The only thing that I can think of is that the first Letter of the question is Always capital and is never starting with the followin 3 characters "A. " or "B. " , "C. " or "E. " .. etc

This is a bout 150000 lines of data, and what I'm trying to achieve is each question in a separate cell (possibly using concatenate function and all the cells sorted alphabetically

they look in a similar format:

A possible consequence for patients taking

cyclosporine is

A. erythematous gingivae and blue mucosa

B. fibrous gingival hyperplasia.

C. loss of soft tissue attachment.

D. epithelial sloughing. .

Which of the following should NOT be

administered to a patient with chest pain

consistent with a myocardial infarction?

A. Epinephrine.

B. Nitroglycerin.

C. Oxygen.

D. Morphine.

E. Acetylsalicylic acid. . A patient has a history of shortness of breath and ankle edema. You would suspect A. asthma. B. emphysema. C. rhinophyma. D. cardiac insufficiency. <tbody> </tbody>

<tbody>
</tbody>

so that they would look like "A patient has a history of shortness of breath and ankle edema. You would suspect A. asthma. B. emphysema. C. rhinophyma. D. cardiac insufficiency." all in one cell