One way, make sure you have plenty of room to the right with empty columns,
select the cell and do datatext to columns, select delimited, click next
then select semicolon, now you will have each string in a separate column,
now select all words and copy them, select a cell where you want to paste
them and then do editpaste special and select transpose



--
Regards,

Peo Sjoblom


"carl" wrote in message
...
I have a string like this in A2

IWM;QQQQ;SPY

Is there a way to have this string transposed in A3,B3,C3 like this:

IWM
QQQQ
SPY

Thank you in advance.