Transpose Question

[Guest]

I have a string like this in a cell:

AU;D7;GL;HJ;R0;R3

Is it possible to transpose it so it looks like this :

AU
D7
GL
HJ
R0
R3

Thank you in advance.

 

[Guest]

Select the cell with your string. Then use Data, Text to column

Then select , Copy, Paste Special, transpose

 

[David Biddulph]

I have a string like this in a cell:

AU;D7;GL;HJ;R0;R3

Is it possible to transpose it so it looks like this :

AU
D7
GL
HJ
R0
R3

Data/ Text to Column, & choose semi-colon as delimiter.
Then select cells, copy, Paste Special/ Transpose