User Profile
Lauraleiwhit
Copper Contributor
Joined 5 years ago
User Widgets
Recent Discussions
Re: 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??252KViews0likes5CommentsRe: CONCAT Function Not Working
AdiAtNoname Same problem here using Excel 2016. I tried to combine two columns of data into one using the =A2&" "&B2 formula example, and also tried =concat(A2," ",B2) and neither are working. When I hit enter all it shows is the formula I entered. I have also check to make sure the Show Formulas button is not selected.252KViews1like7Comments
Groups
Recent Blog Articles
No content to show