+ Reply to Thread
Results 1 to 7 of 7

Macro to Find & Replace Font formats for Multiple Values

  1. 03-09-2018, 05:43 AM #1
    GemBox
    GemBox is offline
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    178

    Macro to Find & Replace Font formats for Multiple Values

    Dear All,

    I want to write a macro to find and replace the words with Bold. For example my document will contain mutilple values like (F#m) (C), (B4), (C#m).
    I want to format the font to bold only for those texts. Can you please help me out.. Please refer the attached document with Actual & Expected.

    Regards,
    Gem
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 03-09-2018, 12:03 PM #2
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Macro to Find & Replace Font formats for Multiple Values

    Why not supply a workbook example
    ,
    Xlorate.com, Selection Codes, YouYube Channel
    Reply With QuoteRegister To Reply
  3. 03-09-2018, 06:01 PM #3
    macropod
    macropod is offline
    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: Macro to Find & Replace Font formats for Multiple Values

    Quote Originally Posted by davesexcel View Post
    Why not supply a workbook example
    Because it's for Word...
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]
    Reply With QuoteRegister To Reply
  4. 03-09-2018, 06:03 PM #4
    macropod
    macropod is offline
    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: Macro to Find & Replace Font formats for Multiple Values

    Cross-posted at: http://www.msofficeforums.com/word/3...le-values.html

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Reply With QuoteRegister To Reply
  5. 03-12-2018, 05:38 AM #5
    GemBox
    GemBox is offline
    Forum Contributor
    Join Date
    04-18-2016
    Location
    India
    MS-Off Ver
    Office 365
    Posts
    178

    Re: Macro to Find & Replace Font formats for Multiple Values

    Quote Originally Posted by macropod View Post
    Cross-posted at: http://www.msofficeforums.com/word/3...le-values.html

    Please read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html
    Sorry, I'm unaware.. Shall I close this thread?
    Reply With QuoteRegister To Reply
  6. 03-12-2018, 06:46 AM #6
    macropod
    macropod is offline
    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: Macro to Find & Replace Font formats for Multiple Values

    There is no need to 'close' the thread. What's important for the future is that you supply the cross-post links whenever cross-posting.
    Last edited by macropod; 03-12-2018 at 06:52 AM.
    Reply With QuoteRegister To Reply
  7. 03-12-2018, 02:01 PM #7
    davesexcel
    davesexcel is offline
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Macro to Find & Replace Font formats for Multiple Values

    Quote Originally Posted by macropod View Post
    Because it's for Word...
    Ha, didn't notice that......
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Find & Replace Multiple Values
    By hobbiton73 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2013, 03:54 AM
  2. Macro to find all specific values in column and replace adjacent cell values
    By dblock02 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-23-2013, 06:03 AM
  3. [SOLVED] Excel macro- Find replace an itallic font word with a regular word?
    By thisisaboutwork in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-08-2013, 01:48 PM
  4. [SOLVED] Faster way to find and replace multiple values with corresponding values
    By babbeleme1 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-18-2013, 06:50 PM
  5. Find / Replace with Multiple Values
    By ciprian in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-29-2011, 02:30 AM
  6. Find and Replace values from multiple lookup values
    By Gregula82 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-22-2007, 03:12 PM
  7. find and replace multiple values
    By nikki115 in forum Excel General
    Replies: 1
    Last Post: 09-13-2006, 01:41 PM
  8. [SOLVED] Is it possible to do a Find/Replace on Conditional Formats?
    By [email protected] in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-21-2005, 09:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1