#Invalid Operation in basic formula in some cells - please help
I need some help with a helper column I created to resolve an issue.
I am currently pulling together 4 non-adjacent multiple-contact columns into one string by using =[column1]1 + [column2]1 + [column3]1 + [column4]1 in a text/number column which displays all the names in one string (thank you @Paul Newcome!)
This is successful for the vast majority, however I've identified a few cells that display #INVALID OPERATION.
I've looked at the contact column cells and nothing is different from these compared to to the other cells. Some of the cells are blank, however this is the case for other rows where the formula is successful.
Could anyone please advise what might be causing the problem?
Thank you for your help,
Help Article Resources
Check out the Formula Handbook template!