Forum Discussion
tinaa140
Feb 06, 2024Copper Contributor
combing multiple cells into one
I am trying to the below into one cell and I keep getting this error. What am I doing wrong.
HansVogelaar
Feb 06, 2024MVP
- Activate the Formulas tab of the ribbon. Make sure that the Show Formulas button in the Formula Auditing group is not highlighted.
- Make sure that the cells containing the formulas are not formatted as Text. If they are, format them as General, then select the top cell, press F2 then enter. Finally, fill down from that cell.