Data/ text to columns will work whether it is 3 elements or 100.
Do that, then copy, and paste special/ transpose.
--
David Biddulph

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