A question with two parts .. please check attachment sir

[Kichan]

I got a question that
A-1,2,B-3,6 and the answer should be
A-1,A-2,B-3,B-6
The requirment is "A-" should be constant in first part and "B-" is constant in second part .. Can we do this kind of questions in Excel ie.. a question having a question with two parts

 

[Kichan]

hi brother,
your formula helped her very much in her work ,thanks , but in some cases she gets survey details in the form where "/" in the place of "-"
how can we modify your formula to get the same result .. thaks

Book1 - Copy.xlsx
	A	B
276	A/1,2,3,4,Z/5,O,P,G	A-1,A-2,A-3,A-4,Z-5,Z-O,Z-P,Z-G
277	10/5,6,7,8,100/2,3,4,1001/A,D,C	10-5,10-6,10-7,10-8,100-2,100-3,100-4,1001-A,1001D,1001C
Sheet1

font color is not importan it is for you to understand the problem more effectively