Feedback by UserVoice

How can we improve Excel for Windows (Desktop Application)?

Improve the Concatenate Function

Make Concatenate to Work with Range of Cells / Arrays rather than 1 cell separated by Comas

The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}

70 votes
Sign in
Password icon
Signed in as (Sign out)

We’ll send you updates on this idea

Sameer Bhide shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
completed  ·  Dan Battagin [MS XL] responded  · 

Update – 2016-03-07

Hi All,

Just wanted to let you know that we’ve completed adding new =CONCAT and =TEXTJOIN functions to Excel 2016 (as part of Office 365 – builds 16.0.6528 and later) that should do what’s been requested here. You can read more about it on our blog:

Dan [MS]


Sign in
Password icon
Signed in as (Sign out)

Feedback and Knowledge Base