| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sorting on only certain characters in a cell
I am trying to sort on a column that contains items such as the following:
P8692 LT6140 3511 The last 4 numbers are the last 4 of a VIN number and are the only ones I want to sort on (would like to ignore the first characters and only sort on the last 4). Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Transfer specific characters from cell to another cell. | New Users to Excel | |||
| characters in a cell | Excel Discussion (Misc queries) | |||
| Ignoring characters when sorting | Excel Discussion (Misc queries) | |||
| cell max characters | Excel Discussion (Misc queries) | |||
| Sorting by Number of Characters | Excel Discussion (Misc queries) | |||
Threaded Mode
