@1.The capital of India. $A) Dushanbe;$B) Moscow;©C) Delhi;$D) Kabul;
@2.The capital of Tajikistan. ©A) Dushanbe;$B) Moscow;$C) Delhi;$D) Kabul;
@3.The capital of Afganistan. $A) Dushanbe;$B) Moscow;$C) Delhi; ©D) Kabul;
Program must check sign = © and letter after sign (for example ©C)Delhi) then separate correct answer in other cell. In result I want output this:
Id
|
Question
|
Answer1
|
Answer2
|
Answer3
|
Answer4
|
CorrectAnswer
|
1
|
1.The capital of India.
|
A) Dushanbe
|
B) Moscow
|
C) Delhi
|
D) Kabul
|
Delhi
|
2
|
2.The capital of Tajikistan
|
A) Dushanbe
|
B) Moscow
|
C) Delhi
|
D) Kabul
|
Dushanbe
|
3
|
3.The capital of Afganistan
|
A) Dushanbe
|
B) Moscow
|
C) Delhi
|
D) Kabul
|
Kabul
|