Excel

RickHolt · Traffic Copper Joined: 17 Mar 2004 Karma :

Ok difficult one for me to describe.

I want to be able to paste text into Excel 2000 and have it auto sort them into cells.

So I paste something like:

Rick <tab> 500 <tab> GS

All at once into excel and it would put Rick into A1, 500 into A2 and GS into A3. Instead of Rick 500 GS all in A1.

Hope you know what I mean and can help :s

Rick

RickHolt · Traffic Copper Joined: 17 Mar 2004 Karma :

Heh never mind, just figured it out, always the way, just after you post to ask how.

RickHolt · Traffic Copper Joined: 17 Mar 2004 Karma :

New Excel question if anyone reads this...

I've got a spreadsheet sorta like this:

(A1) Rick (B1) 23 (C1) GS
(A2) Dan (B2) 68 (C2) CBR
(A3) Mark (B3) -2 (C3) GPZ

The numbers in B are decided using a simple formula relating to other cells, B1= D1-E1.

I want to sort the list by the numbers in B, but when I try to do it obviously, it messes all the numbers up because of the formula. Is there anything I can do to sort it? Confused

dibbster · Nearly there... Joined: 15 Apr 2004 Karma :

Highlight the sheet, goto data then sort and select column b from sort by list, then select ascending/descending. Thumbs Up

____________________
Suzuki RF 600 - The two wheeled Testarossa (Deceased)
Suzuki GSXR - Now stops on a sixpence; SBK3's Thumbs Up

www.bikepics.com/members/dibbster

RickHolt · Traffic Copper Joined: 17 Mar 2004 Karma :

That was the first thing I did, but it messes up the formula so everything goes wrong.

B2 = D2+E2

When they are put in order, B4 (fomerly known as B2) = B4+E4.

God I'm bad at explaining Sad

I'll just put up with them not being in order for now.

Rick

dibbster · Nearly there... Joined: 15 Apr 2004 Karma :

PM me a copy of the file if you want and I will do it.
____________________
Suzuki RF 600 - The two wheeled Testarossa (Deceased)
Suzuki GSXR - Now stops on a sixpence; SBK3's Thumbs Up

www.bikepics.com/members/dibbster