Sorting consecutive numbers with text

Tim A

Hi,

This might have a very obvious answer, I have a list of items with unique numbers, I want to sort them but some of the cells will have additional text, e.g. "34563 item 1".

I want it to look like this:

34563

34563 Item 1

34563 Item 2

34564

34565

But when I sort the column it doesn't put these 'text' cells underneath their numbered counterpart. I end up with something like this:

34563

34564

34565

34563 Item 1

34563 Item 2

etc.

It there a way to sort them consecutively or do I need to move the text to a new column, if so is there a way to avoid doing this manually?

Many thanks,

Tim.

Paul Newcome

Create a separate column that converts everything to text and then sort on this new one.

=[Column Name]@row + ""

(quote quote at the end there)