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



--
Natarajan Ganesan