| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
to make a single row record become multiple row records
hi all,
i copy a set of data and paste in excel. after i paste, i realise that only paste to a single row which is row 1. how to make it to become multiple row records? the data is seperated by a ';'. example: only 1 row of record. it continuous in a single row only panasonic property company ; defino private limited ; luwenor company limit ; .... how to make it to become panasonic property company ; defino private limited ; luwenor company limited ; xesering company limited ; testory company limited ; forento company limited ; |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Build a single order sheet from a multiple page material list. | Excel Discussion (Misc queries) | |||
| Match Single Numeric Criteria and Return Multiple Numeric Labels | Excel Worksheet Functions | |||
| How do I use multiple worksheets as input for a single pivot tab | Excel Worksheet Functions | |||
| Indentify value from multiple values in a single cell | Excel Worksheet Functions | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
Hybrid Mode
