Increment the value of a String from N to O

My requirement is to fetch the cell value from excel sheet which contains a particular date Eg “P1” and then write a particular text to its adjacent Cell like “Q1”. I am able to fetch the cell value (“P1”) but don’t know how to increment it to “Q”. I tried “Char next_char = Convert.ToChar(Convert.ToUInt16(Input) +1)” but that is throwing error “Input String was not in correct format”.


Can you try the following expression? This support address like “AA1”, too.



1 Like

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.