Someone suggested using commas:
"1/ =CONCATENATE(A6," ",B6) 2/ =EXACT(A7,B7) 3/ =FIND("Text",B7) etc"
"Use the comma between the comma in the functions to separate the arguments etc!"

Thank you for trying to help, but I have tried this. It works the same as
without commas (i.e. doesn't work), although the error message is then
less likely to accuse me of too few arguments, just saying that there is an
error in the formula. Remember that I used the function insert wizard
specifically to be sure something like this wasn't the issue.

I ran my computer in "Safe" mode, and tried to reproduce the issue. Then Office
won't even start, accusing me of "Multiple ARP entries found for product"; except
that Office 2010 was loaded on a brand new computer from an unopened package
purchased at BestBuy with the computer. There should be no license problems!