+ Reply to Thread
Results 1 to 8 of 8

Can not find way to bring the text to the right border

  1. #1
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    126

    Can not find way to bring the text to the right border

    Hello,

    I copy from a webpage some text I want to print out. Unfortunately, the text is only about halfway. Then there is a page break.
    How can I format the text that it goes all the way to the right?
    I have tried everything I found on the web.
    I attach a sample file.

    Many thanks
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL (COVID allowing)
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,347

    Re: Can not find way to bring the text to the right border

    You have lots of paragraph breaks cutting off the lines. You can see these if you show formatting marks (press Ctrl-Shift-8 or click the 'Show/Hide' icon in the 'Paragraph' section of the Home tab).

    You can remove these using Find and Replace.

    First select the text which needs to be fixed.
    Now press Ctrl-H to open Find and Replace.
    Put this in the 'Find' box:
    ^p^p

    Put a single space in the 'Replace with' box.
    Click 'Replace All'.

    That should fix it for you.
    Regards,
    Aardigspook

    Recently moved house, internationally, during COVID (!) so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    126

    Re: Can not find way to bring the text to the right border

    Hi Aardigspook, thank you for your reply and solution.
    Actually, I was already so far in Find and Replace, but I could not find the ^p^p.
    I used other codes..... and of course, it could not find any. I used ^v and all those: ^l^b^l^n.

    Regards

    Dorian

  4. #4
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,499

    Re: Can not find way to bring the text to the right border

    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  5. #5
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    126

    Re: Can not find way to bring the text to the right border

    Hi Macropod,

    thank you, wow, this is really a complicated macro. I will try that. Anyway, great for sending me this!

    Regards

    Dorian

  6. #6
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,499

    Re: Can not find way to bring the text to the right border

    Quote Originally Posted by dwc View Post
    wow, this is really a complicated macro
    Not really - just automating the series of Find/Replace operations described in the text.

  7. #7
    Forum Contributor
    Join Date
    09-05-2009
    Location
    Tokyo, Japan
    MS-Off Ver
    Excel 2016
    Posts
    126

    Re: Can not find way to bring the text to the right border

    yes for you simple, for me it looks very complicated!

  8. #8
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,499

    Re: Can not find way to bring the text to the right border

    Almost all of the code could be produced by simply recording the Find/Replace operations using Word's macro recorder. Being as smart as a box of rocks, though, the macro recorder's code would be verbose, to say the least.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to bring text which includes and exludes certain text
    By rizmomin in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-07-2019, 09:20 PM
  2. Replies: 4
    Last Post: 01-08-2016, 07:46 AM
  3. Replies: 1
    Last Post: 12-10-2013, 05:23 PM
  4. Replies: 3
    Last Post: 12-18-2012, 07:19 PM
  5. [SOLVED] Set reference, find it, find where text matches, bring across value
    By gwsampso in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 10-28-2012, 10:59 PM
  6. Replies: 12
    Last Post: 01-14-2008, 03:01 PM
  7. Find a non-blank cell and bring back text a in same row
    By Rod in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 03-24-2005, 06:06 PM

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