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
|