Anyone can solve this??

I have, let's say, a series of 1000 numbers in the column, and the sum of
this numbers on the end.
I want to increase this sum for, let's say, 5%. But, I don't want to
increase this series lineary for 5% (each number increase 5%), than I want
random increase this numbers in range from, let's say, -12% till +17%, but I
have, that firs sum, increase for 5%.
Most important thing is: the same numbers in the series must be
increased/decreased for the same percentage. For example: if the value
156,55 was increased for 6,5% (random number), any values 156,55 must be
increased for 6,5%.
Anyone have some idea how to solve this??

Second problem is:
I have some text pasted from word in excell cells. So, the problem is in
formating cells. Namely, the "enter" in word is pasted like new line in
cell. How can I automate removing this "enter" (new line) in cells thet I
get all text in one line in excell cell. Of corse, with distance between the
word's (space bars)

Eny ideas are welcome.
Sorry for my english!! :-))

Greetings from Croatia

Robert