Yeah I agree there are weird inconsistencies between formulas in Excel, Libre office and Google Sheets. In Excel Concat and concatenate are the same while in google sheets Concat only works for two strings and concatenante is more than two. In Excel other sheet cells are references like Sheet2!A1 but in Libre Office it’s Sheet2.A1 like why??
Yeah I agree there are weird inconsistencies between formulas in Excel, Libre office and Google Sheets. In Excel Concat and concatenate are the same while in google sheets Concat only works for two strings and concatenante is more than two. In Excel other sheet cells are references like Sheet2!A1 but in Libre Office it’s Sheet2.A1 like why??