On May 30, 6:23 pm, carl wrote:
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.

In A3:
=LEFT(A2,FIND(";",A2)-1)
In A4: This is an *array* formula and you can copy it down.
=MID($A$2,SUM(LEN($A$3:A3))+ROWS($A$3:A3)+1,FIND(" ;",$A$2,SUM(LEN($A
$3:A3)+ROWS($A$3:A3))-SUM(LEN($A$3:A3)-ROWS($A$3:A3)+1)))
An *array* formula must be committed with Shift+Ctrl+Enter.

HTH
Kostis Vezerides