Splitting a concatenated string into separate rows...

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

On Thu, 4 May 2006 08:19:01 -0700, Natarajan
<Natarajan@discussions.microsoft.com> wrote:

>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..
>
>
>
>Natarajan Ganesan

snipped

With A1 = "Thisistext" and B1= your predefined string named
"Yourstring"

Put the following in A3 and copy down

=MID($A$1,ROW()-2,1)&yourstring

HTH

__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________