Macro to Find & Replace Font formats for Multiple Values

GemBox · #1 03-09-2018, 04:34 AM

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

gmayor · #2 03-09-2018, 07:46 AM

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.

macropod · #3 03-09-2018, 03:04 PM

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

GemBox · #4 03-12-2018, 02:37 AM

Quote:

Originally Posted by gmayor

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.

Thank you Graham... Can you use the example as per the attached sheet, Pls...

GemBox · #5 03-12-2018, 03:27 AM

Quote:

Originally Posted by gmayor

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, Your formula is not working for (F#m), (C#7), (AbM7), etc...

Can you pls check...

macropod · #6 03-12-2018, 03:50 AM

You could use a wildcard Find/Replace with:
Find = \([!\(]@\)
Replace = ^&
and bold formatting applied to the Replace expression.

GemBox · #7 03-12-2018, 05:24 AM

Quote:

Originally Posted by macropod

You could use a wildcard Find/Replace with:
Find = \([!\(]@\)
Replace = ^&
and bold formatting applied to the Replace expression.

Excellent.. Working fine... Thanks much...

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