Remove parenthesis that contain four digits or etal word vba

vivka · #1 10-30-2023, 12:51 PM

Laith93, I see I have misunderstood your aim: I thought you wanted to delete only four-digit numbers in parentheses and nothing else. So my apologies to Guessed! His code should work properly but unfortnately it doesn't (you are right). I think the following will work:

" \([!\)]@[0-9]{4}*\)"

laith93 · #2 10-30-2023, 07:54 PM

Quote:

Originally Posted by vivka

I think the following will work:
" \([!\)]@[0-9]{4}*\)"

Also, it doesn't work properly, the same action as Andrew code.
Thanks

laith93 · #3 10-31-2023, 11:38 PM

Quote:

Originally Posted by vivka

I think the following will work:
" \([!\)]@[0-9]{4}*\)"

Thank you so much vivka
It works perfectly now (sorry I miscopied the code)
Best Regards

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to convert text that is enclosed inside parenthesis in a word document into numbered footnotes?	BobT	Word	5	07-27-2018 01:17 PM
Find and remove right parenthesis and preceding 11 characters	kevinbradley57	Excel Programming	11	03-25-2018 08:24 PM
Find and Replace Parenthesis with Itallics	Richard Carr	Word	1	01-06-2015 06:44 PM
Separate/ Remove digits from a string of Numbers	QA_Compliance_Advisor	Excel	3	07-23-2014 04:59 AM
Problems merging in last 4 digits of an account higher than 16 digits	Glynda	Mail Merge	1	04-08-2011 12:17 AM