Hi all,

I need an help to split the single into two, is this really possible in excel?

To be precise dividing cell A1 into two different cells(No merging, No text to column option).

Thanks

Elango