+ Reply to Thread
Results 1 to 4 of 4

Make a Entire Line Bold Using Find & Replace

  1. #1
    Forum Contributor
    Join Date
    05-16-2007
    Location
    USA
    MS-Off Ver
    MS Office 2016, Excel 2016
    Posts
    214

    Make a Entire Line Bold Using Find & Replace

    I'm trying to use Find and Replace in Word to make an entire line or all words on a line Bold, but this is proving to be difficult since using the wildcard * after the search criteria does NOT include all of the remaining words or characters on the line. One thing they all have in common is they all have a paragraph return character at the end of the line, but unfortunately, under Find > Special, there is no option for a standard paragraph return character. Closest I could find was a Manual Line Break, which does not even remotely work.

    Any suggestions how I can select the entire line or all content on the line, and then make it bold?

    Example of criteria I am searching for in the document:
    Please Login or Register  to view this content.
    The search criteria is the following:
    check ^t?.*.
    There is an intentional space between check and ^t
    This works for lines that end with a period, BUT fails terribly for lines that do not end with a period.

    I would also like to delete the redundant letter, which is an 'a' in this example, and remove the word 'check', so that all that remains is the following in bold text:
    a. Immerse the burn in cool water.

  2. #2
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    915

    Re: Make a Entire Line Bold Using Find & Replace

    Since you can't use ^p with Jolly characters use this workaround:
    Use Find/Replace to insert a combination of characters that you are sure that aren't presente in your document before every paragraph character ex. Find: ^p Replace: #/#^p (or whatever).
    Then use your Find/Replace with wildcards: check ^t?.*#/# to apply bold where needed and delete the unnecessary.
    And as last, Find/Replace #/# with nothing in all the document (this last operation probably can be merged with the previous).
    Last edited by rollis13; 08-21-2022 at 05:30 PM.

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

    Re: Make a Entire Line Bold Using Find & Replace

    Quote Originally Posted by rollis13 View Post
    Since you can't use ^p with Jolly characters use this workaround:
    Quite unnecessary. Simply use ^13 for the Find (not the Replace) instead of ^p. See:
    https://wordmvp.com/FAQs/General/UsingWildcards.htm

    As for
    Quote Originally Posted by rollis13 View Post
    Jolly characters
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  4. #4
    Valued Forum Contributor rollis13's Avatar
    Join Date
    01-26-2012
    Location
    Cordenons
    MS-Off Ver
    Excel 2016 32bit - Win 11
    Posts
    915

    Re: Make a Entire Line Bold Using Find & Replace

    Quote Originally Posted by macropod View Post
    Quite unnecessary. Simply use ^13 for the Find (not the Replace) instead of ^p. See:
    https://wordmvp.com/FAQs/General/UsingWildcards.htm
    As for
    Okay, okay, that was only a straight translation coming from a tangled mind .
    Last edited by rollis13; 08-22-2022 at 01:44 AM.

+ 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] How to make Bold Line between Unique Values.
    By Mark00963 in forum Excel General
    Replies: 10
    Last Post: 04-29-2021, 03:25 AM
  2. [SOLVED] Find and Replace text with new text but make it bold
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-16-2020, 01:15 PM
  3. [SOLVED] need help with a macro to make certain text within the entire sheet BOLD
    By s2h in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2017, 09:09 PM
  4. [SOLVED] Make the Zero line bold
    By mra1984 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 09-08-2017, 06:27 PM
  5. [SOLVED] When clicking cell within range, make it bold. If already bold, make it not bold
    By jokris in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-08-2016, 07:12 PM
  6. Macro seems to make entire text string in cells Bold
    By Groovicles in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 08-01-2014, 01:30 PM
  7. Need to find a date and if fount replace and if not make new line
    By Tom1687 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-05-2014, 05:39 PM

Tags for this Thread

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