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

Then select , Copy, Paste Special, transpose

"carl" wrote:

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.