separate names and designation from one cell into 2 colmun
Have a look at DataText to columns (separated by semicolom)
Regards,
Stefi
€˛Khoshravan€¯ ezt Ć*rta:
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.
|