Splitting a concatenated string into separate rows...

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
Click to expand...

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
__________________________
 
Back
Top