Posted to microsoft.public.excel.misc

external usenet poster

Posts: 40

sorting numbers and numbers that contain text in excel

A column contains both strictly numbers and also numbers that are followed
by text (e.g., row 1: 1000, row 2: 1500; row 3: 1000a; row 4: 1500a)
Identical numbers are related documents, with the text suffixes referring to
addenda documents; thus, document 1000 has an addendum document 1000a; How
can I sort the column so in the following order: row 1 (1000), row 3 (1000a),
row 2 (1500), row 4 (1500a)?
Thank you
--
MZ

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
sorting text with numbers	wavers3	Excel Worksheet Functions	2	October 27th 09 08:28 PM
Sorting numbers with text	dena320	New Users to Excel	2	June 25th 08 05:06 PM
Help sorting text as numbers	[email protected]	Excel Worksheet Functions	1	November 13th 07 03:34 AM
Sorting numbers as Text	David M.	New Users to Excel	6	July 25th 06 05:46 PM
SORTING TEXT AND NUMBERS	jstephenson	Excel Worksheet Functions	5	February 10th 06 08:44 PM

All times are GMT +1. The time now is 07:19 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us