Home |
Search |
Today's Posts |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
separate names and designation from one cell into 2 colmun
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. |
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) |