LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Merging Two Cells and Keeping the Values Raymond Excel Discussion (Misc queries) 10 May 30th 05 08:05 PM
Merging data from Excel to Word frankfox44 Excel Worksheet Functions 3 April 13th 05 09:25 PM
WRAP a text line over several columns without merging cells Conrad S Excel Worksheet Functions 1 March 22nd 05 03:52 AM
WRAP a text line over several columns without merging cells Conrad Excel Worksheet Functions 0 March 21st 05 11:03 PM
sorting question Brian Excel Discussion (Misc queries) 4 November 28th 04 12:30 PM


All times are GMT +1. The time now is 06:26 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"