Excel formula question

[Sathyat]

I have a cell value ( i.e - A1-A8). Can you guys explain the logic to expand the values. Answer should be A1,A2,A3,A4,A5,A6,A7,A8 . Excel formula would be preferable

 

[Zyndstoff]

I don't know how to solve this via Excel-Formula.
But I can provide a function that does this:

Public Function split(cVal As String)
  On Error GoTo ErrHandle
  solution = ""
  vstart = CInt(Mid(cVal, 2, 1))
  vend = CInt(Right(cVal, 1))
  sletter = Left(cVal, 1)
  For i = vstart To vend
    solution = solution & sletter & i
    If i <> vend Then
      solution = solution & ","
    End If
  Next i
  split = solution
  Exit Function
ErrHandle:
  split = "! Error"
End Function

Copy this in a vba-module. In any Excel cell put "=split(A1)" (assuming your value is in cell A1) and the result will be as desired.