#1
|
|||
|
|||
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 Last edited by Charles Kenyon; 03-12-2018 at 11:49 AM. Reason: Mark as solved |
#2
|
||||
|
||||
You don't need a macro for this.
Perform a wildcard search for \([A-Za-z0-9]{1,2}\) replace with ^& with ctrl+B (bold) applied in the replace dialog.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#3
|
||||
|
||||
Cross-posted at: https://www.excelforum.com/word-form...le-values.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#4
|
|||
|
|||
Thank you Graham... Can you use the example as per the attached sheet, Pls...
|
#5
|
|||
|
|||
Quote:
Can you pls check... |
#6
|
||||
|
||||
You could use a wildcard Find/Replace with:
Find = \([!\(]@\) Replace = ^& and bold formatting applied to the Replace expression.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#7
|
|||
|
|||
Quote:
Regards, Gem |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using wildcards in Find/Replace to change font/case | angie450 | Word | 2 | 05-26-2016 11:09 AM |
Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
Find/replace font colour in all header/footer | trillium | Word VBA | 4 | 10-20-2015 10:39 PM |
how to replace to words with multiple formats | cdk270 | Word | 1 | 07-16-2015 01:56 AM |
Macro for find/replace (including headers and footers) for multiple documents | jpb103 | Word VBA | 2 | 05-16-2014 04:59 AM |