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

Report
Posts
1
Registration date
Monday August 31, 2015
Status
Member
Last seen
August 31, 2015
-
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.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!