Putting a list of numbers into order

[XA04]

Hi,
Basically polishing up some coursework for school, but I need to put a load of numbers into order (which are quite random atm)... is there a quick way of doing this? Preferbly in M$ Word.

Would do it manually.. but there is TONS of numbers.

Thanks!

[streetster]

pop them into excel and do tools->sort

[XA04]

I don't see anything under tools

Edit: Nevermind, found it!. Data >> Sort...
Can't seem to get it to work tho

Fiddled with it and it looks like it's to sort multiple cells..

[Agent]

Seperate the data into different cells then
There is even a wizard to do it

[XA04]

Mind on telling me where to find the wizard?

Edit: Found it, need to put spaces inbetween it all though >_<


Thanks guys.

[Agent]

Whats the current separator in use ?
You can define what you want to use iirc.

[fuddam]

explain the spaces req. Am an excel guru.

how many columns?

if more than one, do you need to sort by a partic column?

do you need to break up data into multiple pieces? - can use text functions to do so

can also sort inside a word table, tho no real need

[atrull]

cat numbers | sort -n

[XA04]

Basically I've got the data in a stem and leaf diagram and need to put it into order.

The way I'm doing at the moment is:

Copy and Paste from M$ word to M$ Excel, In excel: Tools > Text to columns (go to options to change to rows) >> Fixed Width button >> Finish.

Copy and paste into notepad (can't do it into word because of formatting), delete the spaces, then copy and paste again.


I might as well do it by hand because this way is stupid and longer. DOING MY HEAD IN!

That's just for one row, and I need to do a few for each diagram (and there is about 15 diagrams).

[fuddam]

those spaces, where are they?

you can trim spaces from words by using the followin function:

=TRIM(A1) assuming A1 is your first cell

it will remove all spaces from either side of a word, unless in a phrase, in which case it will reduce them to one

You can also then simply copy all the text and paste it over itself via EDIT / PASTE SPECIAL in excel and choose VALUES, if you don't want the formulas any more.

if there are single spaces you want to remove from between 2 words (eg Pig Dog), then can use:

=LEFT(A1,FIND(" ",A1)-1)&RIGHT(A1,LEN(A1)-FIND(" ",A1))

could then do that copy/paste special/ values again if you wanted

shouldn't be any need to go to Notepad.

also, you can swop data from rows to columns by copying it, then PASTE SPECIAL / TRANSPOSE

gimme more info if need be

[fuddam]

ok, had a look at a stem and leaf (before my time - lol)

can't you just copy the text out of Word, paste into Excel, and click the A-Z button?

then copy/paste back?

what do they use to separate the stem from the leaf - a character or a drawn line or a table?

if it's a Word table, you can just turn on the TABLES AND BORDERS toolbar, and use the simple sorting tools there, too. click in the req column and off you go

[XA04]

I've used a table in M$ word to make the stem and leaf diagram.

It basically looks like this:


5|0 1 2 8 4 1 4 6
6|1 2 3 9 1 1

6|1 meaning 61.

So, I have to change it into order, so the row 5 would look like:
5| 0 1 1 2 4 4 6 8


I'm going to begin to do it manually by hand now, will take a while but need it in for tomorrow. Is there an easy way of doing this?

Sorry for any confusion anyone.

Site note: I have made the table in M$ word with two columns, first column is for the 5| and second for the 0 1 1 2... (the pipe symbol doesn't *actually* exist, it's just border colouring).

[fuddam]

gotcha!

ok, now I understand (doh!)

still as easy as pie:

1) paste it into Excel, dividing it by fixed width via the wizard

2) highlight just the area you want to sort - the specific leaf

3) DATA / SORT

4) it will ask if you want to continue with selection - YES

5) click on OPTIONS

6) choose LEFT TO RIGHT

7) bob's ya auntie

you could even record it as a Relative Macro so that a simple click of a button would do the entire process of both Text To Columns & sorting



when you paste it back into word, paste as table then remove certain borders with the eraser, or paste as plain text then use the TEXT TO TABLE tool to rebuild the table as you like, etc.
or even paste as a picture and muck around with that

[XA04]

Thanks. Pretty much what I said I was doing before though (post #9) - and there is still the problem with the spacing if I copy and paste it into notepad - or problem with tables if i copy and paste into word.

Got a high D in this coursework... but the teacher said since I've done so much with it I only need to add a few other little small bits to get it upto a B .


Cheers.

[fuddam]

lol

if you paste it into word from excel as UNFORMATTED TEXT, you can do FIND AND REPLACE to find all the tabs and replace them with single spaces

would do that at the end, since would do them all in one go

resulting data can then be coverted into a table/s

am pretty much trying to avoid doing my own work, methinks - proctrastinator deluxe

[XA04]

How can you paste without formatting? (What I've been doing is pasting to notepad then into word)

And I don't think (or know) how to search for tabs.

Edit: Nevermind, can copy a tab into there... bloody too much trouble tbh.