Is this possible? Is there a way to sort on those numbers without
spliting
them into separate columns?

The easiest way is to use a helper column of formulas to extract the values
on which to base the sort. For example, if
ABC 12345
were in cell A1, then the formula:

=VALUE(MID(A1,FIND(" ",A1)+1,LEN(A1)))

will extract the final number. Copy that down, then select everything and
sort on that column.

HTH,
Bernie
MS Excel MVP


"Abi" wrote in message
...
A co-worker has a spreadsheet with five columns. One of the columns
contains
a string of characters similar to the following:

ABC 12345 description of the project
BBC 30492 another project description
ZZY 01234 a third description of a project

She split that column into three columns so that she could sort on the
numbers. Now she wants to put the rows back together in the order she
sorted
them in.

Is this possible? Is there a way to sort on those numbers without
spliting
them into separate columns?

Thanks!