how to change line at specific place?

[sunchao]

I want to know how to change line in the text ?
For example: change the following text
"11 12 23 24 12 35 14 25 26 98 56 87 41 27 25 65 69"
to
"
11
12
23
24
12
35
14
25
26
98
56
87
41
27
25
65
69
"
You know , I can do this manually by typing the "enter"
key ahead of each number when there are only several or
decades of number. But the things will become
unimaginabale when there are hundreds or thousands of
numbers.
I am looking farward to your wise suggestion.
Thank you!

 

[Greg Maxey]

Sunchao,

Assuming that you will always have pairs of numbers and you have separated
each pair with a space (no paragraph marks), you could use a Find and
Replace.

Edit>Replace>More>Use Wildcards.

Type ([0-9]{2})"and a tap of the spacebar" in the find what field.
Type \1^13 in the replace with field and select replace all.

 

[Peter Jamieson]

Can you be more specific about what you want to do?

If it is a mail merge question, and each number is in a separate record in
the data source, then you should use a Catalog/Directory merge and make sure
there is a paragraph mark after the { MERGEFIELD } used to insert the
number.

If you just have a text with numbers separated by spaces and you want to
change it so that each number os on a separate line, you can use
Edit|Replace to replace a space by ^p (i.e., a paragraph mark.

But maybe you are trying to do something else...

 

[Guest]

-----Original Message-----
I want to know how to change line in the text ?
For example: change the following text
"11 12 23 24 12 35 14 25 26 98 56 87 41 27 25 65 69"
to
"
11
12
23
24
12
35
14
25
26
98
56
87
41
27
25
65
69
"
You know , I can do this manually by typing the "enter"
key ahead of each number when there are only several or
decades of number. But the things will become
unimaginabale when there are hundreds or thousands of
numbers.
I am looking farward to your wise suggestion.
Thank you!

.
Copy the data. In excel select a cell, past special,

select transpose. good luck.