| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"T" function broken?
On Tue, 14 Jul 2009 14:47:30 -0700, Jim Cone wrote:
"to see if it has a 7 character ID no. in it. The first character is always alpha, the remaining 6 are numeric." '-- =AND(CODE(UPPER(B7))64,CODE(UPPER(B7))<91,LEN(B7) =7,ISNUMBER(VALUE(RIGHT(B7,6)))) Thanks to everyone for your helpful replies. Got this one nailed. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can you make a "split" or broken y-axis on a graph in Excel? | Charts and Charting in Excel | |||
| Excel 2007 Bug - "Locked" Property is Broken for Shape Objects | Excel Programming | |||
| Excel 2007 Bug - "Locked" Property is Broken for Shape Objects | Excel Programming | |||
| look for a pipeID in a column and returns "broken" result | Setting up and Configuration of Excel | |||
| "broken" y-axis in Excel charts | Charts and Charting in Excel | |||
Hybrid Mode
