Two problems - I have no idea!!
 

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

Sorry, I didn't completely understand your first query. Maybe somebody else
will have a go at that one.

As for your second query you could select all the cells with the data pasted
from word and run the following macro;

Sub RomoveCR()
With Selection
.Replace what:=Chr(10), replacement:=" "
.Replace what:=Chr(13), replacement:=" "
.WrapText = False
End With
End Sub

Hope this helps
Rowan

"Junior" wrote:

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

Thank you. It's works.
So, how can I explain my first problem to be obvious? Or, to be precisious,
wich part of problem was not clear?

Greetings from Croatia
Robert


As for your second query you could select all the cells with the data
pasted
from word and run the following macro;

Sub RomoveCR()
With Selection
.Replace what:=Chr(10), replacement:=" "
.Replace what:=Chr(13), replacement:=" "
.WrapText = False
End With
End Sub

Hope this helps
Rowan

"Junior" wrote:

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