Help with Excel

inmypocketnottheirs

Hi

I am using Excel as a stock and price list. I have around 500 items on the list, and for historical reasons certain parts of the item numbers hold different information.

An example would be 06JSC5119

At the moment, all items are sorted reading left to right, so they are sorted 06, then JSC, then 5119.

Can I set Excel to sort by just using the last four digits, and if so how do I do this please?

Many thanks


Phil:beer:

tomstickland

Make another column. Use the function "= right(cell_number,4)"
where "cell number" is a cell reference, like A1.

ie: make the cell content the right hand 4 characters of the normal part number cell.Then sort the spreadsheet using that column.

Stompa

inmypocketnottheirs wrote:

Can I set Excel to sort by just using the last four digits, and if so how do I do this please?

I suspect you'd have to add a second column containing just the last 4 characters (e.g. if value in cell A1, put =RIGHT(A1,4) in B1, etc...). Then sort both columns by the new second column.

ukpotters

Remember to copy that formula down and select all the data in the rows before you press sort. If you only choose one column then it will only sort THAT column.

Easy mistake to do!

inmypocketnottheirs

Thanks to both for these replies. Perhaps I should also have said I have absolutely no knowledge of excel at all, this list just gets emailed to me. Is there anyway I can edit an existing list to just ignore the first 5 characters, i.e. just the 06JSC part?

Many thanks

ukpotters

Doing what the other two have said will create a new column (list) with just the last four digits in. Therfore you have ignored the first 5 digits.