I am confused why this simple right() function doesn't work in my Excel 2010.
Column A is formatted as Text, Column B is formatted as General. There are no extra spaces or unusual characters in Cell A1.
Even when the cursor is placed alongside the 2 in the right() function second argument field Excel doesn't make bold the num_chars argument underneath. It's like Excel doesn't accept the second argument I have provided?