how to change line at specific place?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sunchao - 09 Dec 2003 17:36 GMT

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!

Reply to this Message

Greg Maxey - 09 Dec 2003 17:52 GMT

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.

Signature

Greg Maxey
A peer in "peer to peer" support
Rockledge, FL
To e-mail, first edit out the "w...spam" in the displayed address.

> I want to know how to change line in the text ?
> For example: change the following text
[quoted text clipped - 26 lines]
> I am looking farward to your wise suggestion.
> Thank you!

Reply to this Message

Peter Jamieson - 09 Dec 2003 18:10 GMT

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...

--
Peter Jamieson - Word MVP

> I want to know how to change line in the text ?
> For example: change the following text
[quoted text clipped - 26 lines]
> I am looking farward to your wise suggestion.
> Thank you!

Reply to this Message

- 09 Dec 2003 22:07 GMT

>-----Original Message-----
>I want to know how to change line in the text ?
[quoted text clipped - 30 lines]
>.
>Copy the data. In excel select a cell, past special,

select transpose. good luck.

Reply to this Message