For some reason = CONCATENATE("X",A1) formulas have stopped working. I just get #NAME every time. I've noticed when I start to type the formula there is a yellow exclamation in the drop down. Any ideas?


excel error.JPG