Home |
Search |
Today's Posts |
#7
![]() |
|||
|
|||
![]()
Vik
First order of business would be to convert that single column into multiple columns. Use the Excel feature "Text to Columns" to parse this out for you. 1) Highlight the column of data 2) From the menus select Data | Text to Columns 3) Choose Delimited then Next 4) Deselect all Delimiter boxes except check the Comma box 5) Click Finish to do it or Next to add formatting for each column. That should get you to a more usuable database. - John www.JohnMichl.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Automatically sorting data | Excel Discussion (Misc queries) | |||
Sorting data using roman numerals.... | Excel Discussion (Misc queries) | |||
Sorting Data question | Excel Worksheet Functions | |||
Sorting Data from 2 sheets, one sheet which is already sorted | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |