Thanks. I did not explain the problem too well.

My string could be 100 elements long. For example, A;B;C;EE;GGGG;....

I need a formula that can produce this:

A
B
C
EE
GGGG
etc.

Regards.

"Duke Carey" wrote:

You can quickly do a Data-Text to Columns-Delimited and use a semicolon as
the delimiter. That will split the original string into 3 cells that you can
subsequently move

If you want a formulaic approach, use these formulas

A3: =LEFT(A2,SEARCH(";",A2,1)-1)
B3: =LEFT(SUBSTITUTE(A2,A3&";",""),SEARCH(";",SUBSTITU TE(A2,A3&";",""),1)-1)
C3: =SUBSTITUTE(A2,A3&";"&B3&";","",1)

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