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