Splitting a concatenated string into separate rows...

[Natarajan]

How can I use Excel to achieve the following



1) I wish to split a concatenated string into a column of separate characters



“ThisIsTextâ€



should become..



“t

h

i

s

i

s

t

e

x

tâ€.



2) After this I wish to display a predefined row beside every character



t “xyz†“x1w†“234.1wâ€

h “sdf†“w21†“12.5sâ€

i “wer†“we2†“123.eâ€

..

..

..



Thank You



Natarajan Ganesan