Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a worksheet that has 40K rows of part numbers. As these part numbers
are from different suppliers, they have different formats. We are sending this information out in Purchase Orders, via EDI, and we receive Error messages when a non alphanumeric character is included a part number. Is there a way I can use a macro to look at all of these part numbers, and perhaps bold the ones that contain one or more non alphanumeric characters? I have searched high and low, but have not run across a solution to this (obviously). |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
File names appended with ~ plus alphanumeric characters | Excel Discussion (Misc queries) | |||
Search an alphanumeric in a column and return true/false | Excel Worksheet Functions | |||
HOW DO YOU COUNT ALPHA CHARACTERS IN AN ALPHANUMERIC FIELD | Excel Discussion (Misc queries) | |||
format cell to place colon btw every 2 alphanumeric characters | Excel Worksheet Functions | |||
Strip Alpha Characters out of an Alphanumeric Dataset | Excel Programming |