Forum Discussion
CONCAT Function Not Working
SergeiBaklan All data in both columns are formatted as text. But here's what just happened. I tried the formula in a blank worksheet and it worked. Then when I went back to my data worksheet to try again, it finally worked. I entered the same formula again and viola, it worked. I don't know why this was the case. I had originally typed in the cell references instead of selecting them by clicking on them. Is this possibly the trick??
Regardless, my problem is solved.
This might help someone else though??
The problem is not with the referenced cells being formatted as text; it is likely that the formula cell was accidentally formatted as text which will block any formula you may enter into that cell from working.
PeterBartholomew1 THANK YOU. This is exactly the problem I was having and I can't believe it took more than an hour to finally have someone mention this may be the issue. You sir, are a savior.
PeterBartholomew1 I did check that when I was trying to troubleshoot and I believe it was set as General. So how should the formula cell be formatted?
General should be fine. There is a catch in that reinstating General in place of Text doesn't automatically sort the problem. The formula also has to be committed with Enter as if it were newly input.
