data sorting problem

[WATKINS]

I have a large list of file reference numbers in the form 12/34/56789, which I need to sort by the last 2 digits only. Unfortunately each number is confined to a single cell. Rather than transfer by hand to a separate cell is there any way to isolate and sort the numbers I'm interested in? A further complication is that initial zeros are omitted: ie 12/34/(000)89, so the numbers are of varying length.

philip

 

[Legacy 98055]

Hi
Place this formula in an un-used column:

For example:

Your "12/34/56789" numbers are in column A
beginning at row 2 and going to row 2000

Place this in an unused column in row 2:

=Right(A2,2)

Copy the formula down to row 2000
Now sort using the new column as the key.

Tom
This message was edited by TsTom on 2002-04-25 04:46

 

[WATKINS]

fast response Tom, thanks. I knew about delimiting but that wouldn't have done the whole job here. you've saved me and my co-workers quite a bit of time.