Problem with find and replace

macropod · #4 12-11-2012, 04:10 AM

Your specification was:

Quote:

So I need a formula which can find and delete any string of characters between parentheses, but which also must contain a 4 digit number

The wildcard Find/Replace code I posted does that.

If you only want to replace the first instance, use 'Replace', not 'Replace All'. And if you want the choice of which expressions to replace, click 'Find' to go to the first one, then 'Replace' if you want to replace it, else 'Find' to go to the next one. Continue, using 'Replace' or 'Find' each time, as appropriate.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
find & replace with vba	goodhouse	PowerPoint	2	06-10-2012 12:10 AM
Bad view when using Find and Find & Replace - Word places found string on top line	paulkaye	Word	4	12-06-2011 11:05 PM
Is there a way to use "find/replace" to find italics words?	slayda	Word	3	09-14-2011 02:16 PM
Find/Replace Brackets Problem	fatso	Word	2	08-04-2011 11:34 AM
Help with find and replace or query and replace	shabbaranks	Excel	4	03-19-2011 08:38 AM