Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
my TEXT function won't work
I have a spreadsheet with columns of data. The data is extracted from a
string using either the MID or LEFT functions, and then I use the TEXT function to make sure it is formatted as text.One column is surnames which I need to sort alphabetically A .. Z. Instead of sorting all of the list alphabetically it sorts most of it, then after Z it has another 20 or so names starting again from A through to Z. Am I doing something wrong ... why won't it sort the whole column of names! .... Roger |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
my TEXT function won't work | Excel Worksheet Functions | |||
Why does my Function not work? | Excel Discussion (Misc queries) | |||
how does the AVERAGE function work? | Excel Discussion (Misc queries) | |||
how to use work date function | Excel Worksheet Functions | |||
how do i get the mid function to work with a zero | Excel Worksheet Functions |