Transposing a Long String
 

I use some long strings like these:

A0;A4;A5;A6;A8;A9;AC;AS;AI;AK;AN;AO;AP;AQ;B5;B9;BA ;BB;BC;BD;BE;BH;C2;C3;C4;CA;CB;CC;CG;CH;CI;CK;D0;D 2;D3;D5;D6;E1;E3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G 9;GC;GE;H2;H3;H6;I0;DA;B7;J0;J4;K0;K2;K3;L0;L2;L3; L5;L7;L9;M1;M3;M5;M7;M8;M9;MA;MB;MF;MH;N0;N4;N5;N6 ;N7;N8;AG;P0;P1;P6P8;Q0;Q3;R1;R4;S0;S1;S2;S3;S5;S6 ;S7;SA;SB;SC;SD;SE;T1;T2;T3;T8;U0;U3;U4;V0;V1;V4;W 2;W3;W4;X0;X1;X2;Y0;KO;LO;MO;NO;OO;PO;QO;RO;SO;TO; UO;VO;XO;FP;GP;HPIP;JP;KP;LP;MP;NP;OP;PP;QP;RP;SP; TP;UP;VP;WP;YP;FQ;GQ;HQ;IQ;KQ;LQ

The string is in 1 cell.

Is there a way to take the string and transpose it into separate rows. For
example:

A0
A4
A5
..
..
..
LQ

Thank you in advance.

Hi
one way without VBA or formulas:
1. Use 'Data - Text to columns' and the semicolon as delimter to split the
string in separate columns
2. Copy these cells
3. Paste them with 'Edit - Paste Special - Transpose'

--
Regards
Frank Kabel
Frankfurt, Germany
"carl" schrieb im Newsbeitrag
...
I use some long strings like these:

A0;A4;A5;A6;A8;A9;AC;AS;AI;AK;AN;AO;AP;AQ;B5;B9;BA ;BB;BC;BD;BE;BH;C2;C3;C4;CA;CB;CC;CG;CH;CI;CK;D0;D 2;D3;D5;D6;E1;E3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G 9;GC;GE;H2;H3;H6;I0;DA;B7;J0;J4;K0;K2;K3;L0;L2;L3; L5;L7;L9;M1;M3;M5;M7;M8;M9;MA;MB;MF;MH;N0;N4;N5;N6 ;N7;N8;AG;P0;P1;P6P8;Q0;Q3;R1;R4;S0;S1;S2;S3;S5;S6 ;S7;SA;SB;SC;SD;SE;T1;T2;T3;T8;U0;U3;U4;V0;V1;V4;W 2;W3;W4;X0;X1;X2;Y0;KO;LO;MO;NO;OO;PO;QO;RO;SO;TO; UO;VO;XO;FP;GP;HPIP;JP;KP;LP;MP;NP;OP;PP;QP;RP;SP; TP;UP;VP;WP;YP;FQ;GQ;HQ;IQ;KQ;LQ

The string is in 1 cell.

Is there a way to take the string and transpose it into separate rows. For
example:

A0
A4
A5
.
.
.
LQ

Thank you in advance.

If your string were in A1 of Sheet1, place this in A1 of
a new worksheet and copy down:

=MID(Sheet1!$A$1,ROW()*3-2,2)

HTH
Jason
Atlanta, GA

-----Original Message-----
I use some long strings like these:

A0;A4;A5;A6;A8;A9;AC;AS;AI;AK;AN;AO;AP;AQ;B5;B9;B A;BB;BC;
BD;BE;BH;C2;C3;C4;CA;CB;CC;CG;CH;CI;CK;D0;D2;D3;D5 ;D6;E1;E
3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G9;GC;GE;H2;H3;H 6;I0;DA;
B7;J0;J4;K0;K2;K3;L0;L2;L3;L5;L7;L9;M1;M3;M5;M7;M8 ;M9;MA;M
B;MF;MH;N0;N4;N5;N6;N7;N8;AG;P0;P1;P6P8;Q0;Q3;R1;R 4;S0;S1;
S2;S3;S5;S6;S7;SA;SB;SC;SD;SE;T1;T2;T3;T8;U0;U3;U4 ;V0;V1;V
4;W2;W3;W4;X0;X1;X2;Y0;KO;LO;MO;NO;OO;PO;QO;RO;SO; TO;UO;VO
;XO;FP;GP;HPIP;JP;KP;LP;MP;NP;OP;PP;QP;RP;SP;TP;UP ;VP;WP;Y
P;FQ;GQ;HQ;IQ;KQ;LQ

The string is in 1 cell.

Is there a way to take the string and transpose it into
separate rows. For
example:

A0
A4
A5
..
..
..
LQ

Thank you in advance.


.