Tend to agree that choice of + for string concatenation was a mistake - anyone know the history/first widely used example? Did the original BASIC have it? (I think QuickBasic did, but that's unlikely to be the origin).

Edit: found https://retrocomputing.stackexchange.com/questions/20460/wha..., suggests it was ALGOL-68.

the '+' operator provides concatenation of strings in both python and C; in Excel, you use '=CONCAT()'... just syntactic differences, is all.

It's not just a syntactic difference. It's a huge UX difference that one operator always does an addition on both numbers and numeric strings, and another operator always concatenates both numbers and numeric strings.

The looser your typings the more it matters, and spreadsheets barely even have types.

Yeah, I spend more time doing data manipulation in python than in excel, so I thought that excel would do that as well.

In C? How?

sorry, meant cpp! C (apparently) uses a function that more closely resembles Excel

C has strcat but that only does the easy part - allocating and freeing the memory is still the caller's b job.