Excel Find and Replace formatting still running even after Clear Replace Format is set

jscranton

Well-known Member
Joined
May 30, 2011
Messages
707
I was trying to find and replace certain text with bold/underline. I originally was trying to use the Replace Format option in the Ctrl-H Find and Replace tool. But, it replaced all the text in a cell with bold/underline so I wrote a script to handle.

However, I now can't use Find and Replace at all without bold & underlining everything. I have Cleared the Replace Format. I have closed excel down completely.

How do I clear this out?
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,655
Office Version
  1. 365
Platform
  1. Windows
If you closed xl down, then you already have :)
 

Watch MrExcel Video

Forum statistics

Threads
1,109,533
Messages
5,529,404
Members
409,871
Latest member
i1patrick
Top