Regular Expressions: [!0-9] does not work???

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Regular Expressions: [!0-9] does not work???

05-29-2012, 09:14 AM

Colin Legg Colin Legg is offline

Windows 7 32bit Regular Expressions: [!0-9] does not work???

Office 2010 32bit

Expert

Join Date: Jan 2011

Location: UK

Posts: 369

I think you mean to use this:

Code:

.Pattern = "[^0-9]"

Which could be simplified to:

Code:

.Pattern = "\D"

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
work vs regular work. and how regular work works	user0044	Project	5	03-06-2012 07:28 AM
regular Expressions Formatting for Search	sesproul	Mail Merge	1	11-30-2011 05:02 AM
Access 2003 says unsafe expressions not blocked, but only some users on same computer	ZLA	Office	3	07-23-2010 10:00 AM
Issue skipping characters by Regular Expressions in Word	pochtara	Word VBA	0	04-01-2010 05:37 AM
How do I have headers and footers appear as regular text for the whole document?	user908045	Word	0	03-13-2010 12:41 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:21 PM.