Transpose Question
 

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.

Transpose Question
 

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.

Transpose Question
 

"carl" wrote in message
...
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
--
David Biddulph