So use Data Text to Columns with semi-colon as delimiter.
Copy that row then Edit/ paste special/ transpose to paste into a column.
Data Text to columns on the new column range with hyphen as delimiter.
--
David Biddulph

"Khoshravan" wrote in message
...
To complete my question, I should add that whole text in cell A1 has 17840
characters (Len(A1)). Also there might be some spaces between names, but
the
exact format which is same through all names is "-"between name and
designation and ";" between a pair of names and designations.
--
R. Khoshravan
Please click "Yes" if it is helpful.


"Khoshravan" wrote:

I have copied a list of employee names and their designation into Excel.
All
list appear in one cell. There are about 500 names. Names are followed by
employee designation. The format is as follows:
"name-designation;name-designation" and repeats for 500 names
I want to have names in one column and designation in second column
separated.
--
R. Khoshravan
Please click "Yes" if it is helpful.