Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Word Spacing


  • Please log in to reply

#1
qwerty2487

qwerty2487

    New Member

  • Member
  • Pip
  • 2 posts
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?
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
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
  • 0

#3
dsenette

dsenette

    Je suis Napoléon!

  • Administrator
  • 26,019 posts
  • MVP
you could also do edit > paste special > and choose to paste it as unformatted text...which will remove any formatting from the original document
  • 0

#4
qwerty2487

qwerty2487

    New Member

  • Topic Starter
  • Member
  • Pip
  • 2 posts
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.

  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP