Reply to thread

Message: [QUOTE="JoeU2004, post: 13408632"] =if(B3="", "", char(code(A2)+1)) Sorry, but these do not make sense to me. In the first formula, if A2 is 0 or 1, what is wrong with the A2+1 or A2&"a"? The first will result in 1 or 2; the second will result in "0a" or "1a". If that is not the result you want, exactly what result do you want? In the second formula, A2+1 makes no sense if A2 is "A", "AA", "1A" or "A1". And it makes no more sense to me in the context of your original question. Again, exactly what result do you want? PS: In the second formula, it is poor form to omit the "value_if_false" part. Your formula will result in FALSE if B3 is not "" and B3=B2. If you need help, it would be prudent to explain what result you want in that case, too. ----- original message ----- [/QUOTE]