Forum Discussion
Solved
Can't join two data cells with ampersand
I'm trying to combine the values of two adjacent columns. It's the common FirstName and LastName thing. I've read in Microsoft support about using the ampersand. I followed the instructions carefully...
Caesar240 Either the cell where you entered the formula was formatted as text before you entered it or you accidentally pressed the "Show Formulas" button on the Formulas ribbon.
Format he cell as Number and re-enter the formula or press the "Show Formulas" button again.
One more possible reason if you use on Mac curvy quotation mark instead of normal one ( " ).