| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate names and designation from one cell into 2 colmun
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need to separate first and last names from one cell to two | Excel Discussion (Misc queries) | |||
| Names and Separate Worksheets | Excel Worksheet Functions | |||
| cell designation | Excel Discussion (Misc queries) | |||
| Invisible Text designation in cell? | Excel Worksheet Functions | |||
| How I can set highlighted active cell in row & colmun cross | Excel Discussion (Misc queries) | |||
Threaded Mode
