[qwerty2487]

Hey guys, I have the task of reorganizing some data from work. My problem is that it requires pasting old data into word files. When i do this there are a lot of uneccessary spacings that occur due to the original data. Its very tedious to remove that spacing one at a time. Can anyone help me with a faster way?

Example of what I mean:

6%
14%

67%


85%

95%
60%
24%
41%


10%
39%

23%

I need all the spacing in between those numbers to be gone instantly...is there anyone who can help?

[Advertisements]

Qwerty
Try this

Edit > Select All
Edit > Replace
Find What > ^p^p this indicates two paragraph marks
Replace With > ^p this indicates one paragraph mark
Replace All


You may need to run this a few times depending on how many lines are between individual entries
If you know there is often 5 or 6 paragraph marks between data start with this number of ^p in your find what cell, then go to a smaller number. To remove all lines you must finish with replace 2 with 1.


Hope this helps
DSM

[dsm]

Qwerty
Try this

Edit > Select All
Edit > Replace
Find What > ^p^p this indicates two paragraph marks
Replace With > ^p this indicates one paragraph mark
Replace All


You may need to run this a few times depending on how many lines are between individual entries
If you know there is often 5 or 6 paragraph marks between data start with this number of ^p in your find what cell, then go to a smaller number. To remove all lines you must finish with replace 2 with 1.


Hope this helps
DSM

[dsenette]

you could also do edit > paste special > and choose to paste it as unformatted text...which will remove any formatting from the original document

[qwerty2487]

Thank you guys, that did the trick. You've just saved me hours of tedious work. I'd thought of the replace function, but I didn't know how to make it search for paragraph marks, now I know!

Cheers

Edited by qwerty2487, 30 May 2006 - 02:55 PM.