Data - Text to Columns, delimited by semicolon.
Select Data, copy, paste special - transpose.

--
Best Regards,

Luke M
"carl" wrote in message
...
I have some strings like this (some are as long as 4000 separated values):

A;AA;AAI;AAP;AAPL

I am looking for a way to convert these strings into column data like
this:

A
AA
AAI
AAP
AAPL


Thank you in advance.