Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort Excel Column on Fifth Character
Hi,
Is it possible to sort an Excel column on the fifth character? If so, how is it done? If not, is it possible to write a macro to copy each Excel column to Access, sort the column on the fifth character in Access, and copy the column back to Excel? And if so, how? Would this be further complicated because each Excel column is filled with items from a drop-down menu that exists only in each column itself? -- Dolores |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort Excel Column on Fifth Character
Insert a new column alongside your data and use the MID function to extract
the character on which you want to sort into the new column Let's assume the column you want to use for sorting is D. Use =mid(D2,5,1) to extract the 5th character. Copy the formula to all rows, then sort on that column "Dolores" wrote: Hi, Is it possible to sort an Excel column on the fifth character? If so, how is it done? If not, is it possible to write a macro to copy each Excel column to Access, sort the column on the fifth character in Access, and copy the column back to Excel? And if so, how? Would this be further complicated because each Excel column is filled with items from a drop-down menu that exists only in each column itself? -- Dolores |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sort Excel Column on Fifth Character
Thanks very much, Duke. You're a life saver!
-- Dolores "Duke Carey" wrote: Insert a new column alongside your data and use the MID function to extract the character on which you want to sort into the new column Let's assume the column you want to use for sorting is D. Use =mid(D2,5,1) to extract the 5th character. Copy the formula to all rows, then sort on that column "Dolores" wrote: Hi, Is it possible to sort an Excel column on the fifth character? If so, how is it done? If not, is it possible to write a macro to copy each Excel column to Access, sort the column on the fifth character in Access, and copy the column back to Excel? And if so, how? Would this be further complicated because each Excel column is filled with items from a drop-down menu that exists only in each column itself? -- Dolores |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
excel change default column sort to current selection | Excel Worksheet Functions | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
HELP! How do you--> Lock a set of rows but also link worksheets to | Excel Discussion (Misc queries) | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |