+ Reply to Thread
Results 1 to 3 of 3

Transposing a Long String

  1. #1
    carl
    Guest

    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;D2;D3;D5;D6;E1;E3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G9;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;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;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.



  2. #2
    Frank Kabel
    Guest

    Re: Transposing a Long String

    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" <[email protected]> schrieb im Newsbeitrag
    news:[email protected]...
    >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;D2;D3;D5;D6;E1;E3;E4E9;F3;F6;F7;F8;G0;G2;G4;G7;G8;G9;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;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;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.
    >
    >




  3. #3
    Jason Morin
    Guest

    Re: Transposing a Long String

    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;BA;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;H6;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;R4;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.
    >
    >
    >.
    >


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1