July 13, 200619 yr If I parse the letter 'A' out of a field is there any function or other that will tell me that the next letter alphabetically is 'B'. Parse a 'B' and the next letter is 'C' etc Thanks in advance Phil
July 13, 200619 yr Hi, assuming that the field that holds the letter to parse is named: "parse a letter" the calc for the next letter is: Let( string = "ABCDEFGHJKILMNOPQRSTUVWXYZ"; Middle (string; Position ( string ; parse a letter ; 1 ; 1 ) + 1 ; 1 ) )
Create an account or sign in to comment