Transpose Question

C

carl

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.
 
H

hans bal(nl)

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

Then select , Copy, Paste Special, transpose
 
D

David Biddulph

carl said:
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
Click to expand...

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