Extract the number A1-A10 like a A1,A2,A3,A4,A5,A6,A7,A8,A9,A10

Closed
shivarajed Posts 1 Registration date Monday August 31, 2015 Status Member Last seen August 31, 2015 - Aug 31, 2015 at 12:30 AM
Dear Team,

I Need extract the Number like a below in excel sheet

Cell A1 have a character is "A1-A10"
Cell B1 need to extract A1,A2,A3,A4,A5,A6,A7,A8,A9,A10

kindly provide the formula to us.