Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to move data from single to multible collums in excel
I'm trying to move grouped data from a single collum to multible collums.
Each group is separate by a comma |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to move data from single to multible collums in excel
I'm trying to move grouped data from a single collum to multiple collums.
Each group is separate by a comma Try Data Text to Columns, delimiter: comma -- Max Singapore http://savefile.com/projects/236895 Downloads:19,500 Files:362 Subscribers:62 xdemechanik --- |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to move data from single to multible collums in excel
Hi Don
Ensure that you have sufficient blank columns to the right of your column of data. DataText to ColumnsDelimitedtick CommaFinish -- Regards Roger Govier "Don" wrote in message ... I'm trying to move grouped data from a single collum to multible collums. Each group is separate by a comma |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
single entry across multible sheets in workbook | Excel Worksheet Functions | |||
Manipulating data in Multible worksheets | Excel Worksheet Functions | |||
Excel 2007: Create a pivot table where data is in multible sheets | Excel Worksheet Functions | |||
Importing Data from Multible Ranges in Excel Sheet | Excel Discussion (Misc queries) | |||
move data to a single cell and at the same same time filter the da | Excel Discussion (Misc queries) |