| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can data be sorted by the length in a field
Thanks, worked perfectly.
"Gary''s Student" wrote: Use a helper column. Say the text data is in column A. In B1 entrer: =LEN(A1) and copy down. Then sort cols A & B by B. -- Gary''s Student - gsnu200906 "NanAnn58" wrote: Swithching to a new computer system at work and the current description field has 35 characters and the new description field only has 30. I am trying to sort the original description field that I dumped into excel by the length of the field. Is this possible? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| //sk - Max length of a numeric field. | Excel Worksheet Functions | |||
| Pivot Table Field Values not sorted | Excel Discussion (Misc queries) | |||
| Pad field length | Excel Discussion (Misc queries) | |||
| Field length of VBA totals in Excel 2003 | Excel Discussion (Misc queries) | |||
| How do I fix a field length? | Excel Discussion (Misc queries) | |||
Hybrid Mode
