split one cell to as many cells as many digits/alphabets of the cell

**roofi** · 06-24-2013, 06:19 AM

Dear all,
here is attached sample file. please review for solution. question is in the worksheet.

thanks

**:) Sixthsense :)** · 06-24-2013, 06:21 AM

In E4 Cell

Formula:

Please Login or Register  to view this content.

Drag it to right...

**roofi** · 06-24-2013, 06:27 AM

thanks Sixthsense
it solves the matter.

**:) Sixthsense :)** · 06-24-2013, 06:37 AM

Glad it helps you and thanks for the feedback

**roofi** · 06-24-2013, 07:28 AM

Dear Sixthsense,
How to split cell containing date?

Like date 24-10-98

please review

thanks

**:) Sixthsense :)** · 06-24-2013, 07:31 AM

If possible please show it in excel for getting better understanding of the data

**roofi** · 06-24-2013, 07:41 AM

dear
please review this sheet
thanks

**:) Sixthsense :)** · 06-24-2013, 07:44 AM

In E4 Cell

Formula:

Please Login or Register  to view this content.

Drag it to right...

**roofi** · 06-24-2013, 08:15 AM

Great....................... it works.
Thanks

Re: split one cell to as many cells as many digits/alphabets of the cell