| 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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting on only certain characters in a cell
Lesa,
In another column, enter the formula =right(a1,4) Where a1 can be replaced with the cell value that contains the entire vin. You can then sort on this new column. -- http://www.ExcelHelp.us 888-MY-ETHER ext. 01781474 "Lesa" wrote: 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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting on only certain characters in a cell
On Nov 25, 12:31*pm, Lesa wrote:
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? Assuming your data is in column A You could insert a hidden column next to your data, and then us a =Right(A1,4) to get the VIN and sort by it. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Sorting on only certain characters in a cell
Thanks you mcshcher and galimi! Worked just as you said!
"mcescher" wrote: On Nov 25, 12:31 pm, Lesa wrote: 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? Assuming your data is in column A You could insert a hidden column next to your data, and then us a =Right(A1,4) to get the VIN and sort by it. |
| Reply |
| 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) | |||
Linear Mode
