A1 always refers to column A and row 1. The New-OldOld formula always works. Example MAXA1A5 Result 9 See Image below 8 LEN in Excel.
If a part of the formula is in parentheses that part will be calculated first.
ASCII characters are pretty limited though and sometimes youll need a wider variety of symbols. CHAR 128 C4 press enter. Characters in Excel are the letters numbers and special characters. When comparing text values Microsoft Excel ignores their case and compares the values symbol by symbol a being considered the lowest text value and z - the highest text value.