Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to test a cell's value to see if it takes the form
?/? where ? should simply be integers.....something like 2/1 or 27/1 or 256/1 The requirement is for the value to be in the form integer/1 I have: varr = Split(FirstPageNumber, "/") where FirstPageNumber holds the value of the cell in question (as a String). This works (sort of) but not in all cases (eg when "/" is missing). I need to do this test just once for each sheet, and wish to get the integer value. Would appreciate some help, please. Regards. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
A/B split testing question | Excel Discussion (Misc queries) | |||
Very basic pivottable question (XL2003) | Excel Discussion (Misc queries) | |||
Split UPC Question | Excel Discussion (Misc queries) | |||
Split & Trim question | Excel Programming | |||
Right & Split question | Excel Programming |