Copy and Paste + erasing date
 

HI guys, I have two questions

When pasting, how do you invert data you have copied in the one cell
without affecting other cells, eg I copied
800
594
1002
754
410
But I want to paste it as
410
754
1002
594
800

Question 2
I have data 10/23/07, 100
10/24/07, 115
10/25/07, 99
The data is connected when I paste it, but all I want are the numbers
100
115
99
How can I remove the date in front?

Thanks in advance

Copy and Paste + erasing date
 

The easiest way of inverting the data is to add an auxilary row with the
number 1,2,3,4,.... You can just put in 1 and 2 in the 1st two cells and the
use autofill. Next sort numbers in descending numbers to reverse your
original numbers.

To seperate the date from the numbers use on worksheet menu Data - Test to
column. Select Delimited and then on next menu select sperator as a comma.

"KU" wrote:

HI guys, I have two questions

When pasting, how do you invert data you have copied in the one cell
without affecting other cells, eg I copied
800
594
1002
754
410
But I want to paste it as
410
754
1002
594
800

Question 2
I have data 10/23/07, 100
10/24/07, 115
10/25/07, 99
The data is connected when I paste it, but all I want are the numbers
100
115
99
How can I remove the date in front?

Thanks in advance