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

=CONCATENATE(Array,Seperator)
The Array to Accept A1:A10 or A1:D1 or {"Abb","Areva","BHEL"} or {"ABB";"Areva";"BHEL}
or

70 votes
Sign in
(thinking…)
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:

https://blogs.office.com/2016/02/23/6-new-excel-functions-that-simplify-your-formula-editing-experience/

Cheers,
Dan [MS]

19 comments

Sign in
(thinking…)
Password icon
Signed in as (Sign out)
Submitting...

Feedback and Knowledge Base