Regular Expressio to fnd data with non-numeric data

I need a regular expression to find cells that contain non-numeric data.  For example; I need to find the rows below that are listed as invalid.

!2030009D0000              --> This is invalid
9999999999999             ---> This is valid
Test                                 --> This is invalid
0000000111109            ---> This is valid
  0  0  9                           ---> This is Invalid
66719999%000             ---> This is Invalid
Who is Participating?
AshokConnect With a Mentor Commented:
since you say cell i'm think excel in which case you could use

If IsNumeric(Range("A1")) Then
hojohappyAuthor Commented:
No not EXCEL.
Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

in perl could use

$numeric =~ m/(\d+)/;
Regular expression to find cells that contain non-numeric data:


Open in new window

Terry WoodsIT GuruCommented:
I think you just want to use this pattern to find non-numeric values:

Open in new window

käµfm³d 👽Commented:
What programming language or text editor are you using? Mazdajai's suggestion is probably the most portable (though you might need to remove the ^ and $ depending on your needs).
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.