+ Reply to Thread
Results 1 to 3 of 3

macro to format text in Word which is copied from the internet

  1. #1
    Registered User
    Join Date
    04-19-2012
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    26

    macro to format text in Word which is copied from the internet

    I often have the problem of not being able to format text copied from webpages correctly.

    For example I might paste (Keep Text Only) a piece of text such as:

    Studies showing that this also results in similar gains
    outside reserves are fewer in number, and more variable in
    conclusions reached. Accordingly, it is difficult to ascertain
    whether marine reserves are beneficial
    for harvestable fish stocks.

    The problem is that it comes with line breaks whereas I want to go right across the page in Word without an early line break.

    So to have it look like

    Studies showing that this also results in similar gains outside reserves are fewer in number, and more variable in conclusions reached. Accordingly, it is difficult to ascertain whether marine reserves are beneficial for harvestable fish stocks.

    At the moment what I do is just backspace and space bar as I go through each line.

    I'm sure there is a better way to do this but I don't know how.

  2. #2
    Valued Forum Contributor
    Join Date
    06-16-2006
    Location
    Sydney, Australia
    MS-Off Ver
    2013 64bit
    Posts
    1,394

    Re: macro to format text in Word which is copied from the internet

    Try using the replace feature. Highlight the text, the press Ctrl-H. Find the character you don't want (I think you need to select special characters or something). The put nothing as the replace string, and replace all

  3. #3
    Registered User
    Join Date
    04-19-2012
    Location
    Hamilton, New Zealand
    MS-Off Ver
    Excel 2007
    Posts
    26

    Re: macro to format text in Word which is copied from the internet

    Works great! Cheers for that.

    In the replace feature I just clicked on the [more>>] button then click on [Special], then selected "manual line break" from the menu to put into the find field and left the replace field blank as you said.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1