On Thu, 4 May 2006 08:19:01 -0700, Natarajan
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
__________________________