Forum Discussion
Array formulas in excel
Hello everyone, I just recently moved from Google Sheets to Excel. Already facing some challenges. Hope someone can help me with it. So, in Google sheets, in case you want your formula to expand d...
=MAP(A2:A8,B2:B8,LAMBDA(name,surname,IF(name="","",TEXTJOIN(" ",,name&" "&surname))))You can try this formula which returns the intended result in my sheet.