| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Text string sort limit
I concatentated several columns of data to use as a vlookup match key between
some database query results and some existing spreadsheet data. The concatenated string is all numeric, 27 characters long, but formatted as text. The Excel 2003 sort appears to have a limit to the number of characters it will sort as a text string. Is this issue documented anywhere? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Text string sort limit
I don't think there is any limit.... other than limit on number of characters
in a column. You are probably having trouble as you have a formula in the cells.... To test, paste special as values and then sort... "Bob Laverty" wrote: I concatentated several columns of data to use as a vlookup match key between some database query results and some existing spreadsheet data. The concatenated string is all numeric, 27 characters long, but formatted as text. The Excel 2003 sort appears to have a limit to the number of characters it will sort as a text string. Is this issue documented anywhere? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Limit decimal places in a string cell reference | Excel Discussion (Misc queries) | |||
| Change 3 letter text string to a number string | Excel Discussion (Misc queries) | |||
| Limit to string length in search@replace? | Excel Discussion (Misc queries) | |||
| Problem with VB string character limit. | Excel Worksheet Functions | |||
| Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
Linear Mode
