2 Replies Latest reply on Aug 2, 2012 4:41 AM by Brian Near

    Finding a number in a fixed position in string

    Brian Near

      I need to determine whether the 3rd character in a string is a number.  Was hoping to find an "ISNUM()" function, but no luck.

      Can someone suggest a workaround formula? 

      If there's a similar formula that can be applied to determine if the same character is alpha, that would also be appreciated.