View Single Post
  #1   Report Post  
Abi
 
Posts: n/a
Default Sorting, Merging, and Re-merging

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!