How to split the excel cell values

Hi,

In a excel i have a input as string value & i want output like in the picture.

image

Thanks,