Is possible to shuffle answers in multiple choice test in EXCEL?

[t0m1noo]

I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D).
For example:

Is possible to do that by using VBA or with some formula?

Thanks for the help.

 

[Peter_SSs]

.. or without looping:

Sub QuestionNumbers()
  With Range("A1").CurrentRegion.Offset(, 2)
    .Value = Application.Transpose(Filter(Application.Transpose(.Offset(, -2)), ".)", True))
    .Replace What:=".)*", Replacement:="", LookAt:=xlPart
    .Replace What:="(", Replacement:="", LookAt:=xlPart
    .Replace What:="#N/A", Replacement:=""
  End With
End Sub