LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
carl
 
Posts: n/a
Default 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.


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Extract hyperlink string from excel cell Ryan Sapien Links and Linking in Excel 1 January 20th 05 12:24 AM
Read Text File into Excel Using VBA Willie T Excel Discussion (Misc queries) 13 January 8th 05 12:37 AM
Formula to list unique values JaneC Excel Worksheet Functions 4 December 10th 04 12:25 AM
Decimal to Binary Himu Excel Worksheet Functions 15 November 22nd 04 07:13 PM
Delemited string Pierre Leclerc Excel Worksheet Functions 2 November 21st 04 06:45 AM


All times are GMT +1. The time now is 07:37 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"