Enable concatenation of a range
 

The current syntax of CONCATENATE() is CONCATENATE (text1,text2,...).
Using it thus: CONCATENATE(A1:C3) is impossible. Of course, one should think
of the order in which the cells are concatenated, since the case is different
than that of SUM, AVERAGE or PRODUCT due to the concatenation's lack of
commutability.
In order not to mess up the existing function, I suggest a new function with
this syntax:
CONCATRANGE(range, order1, order2, order3)
range - the range of cells to be concatenated
order1 - 0 or omitted for concatenating row after row, 1 for concatenating
column after column.
order2 - 0 or omitted for concatenating rows with the sheet's direction (as
the column letters increase), 1 for concatenating rows in the reverse order
(as the column letters decrease).
order3 - 0 or omitted for concatenating columns with the sheet's direction
(as the row numbers increase), 1 for concatenating columns in the reverse
order (as the row numbers decrease).
Example:
=CONCATRANGE(A1:B3, 1, 0, 1) is equivalent to =A2&A1&B2&B1&C2&C1.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc

There are functions written by third party that will do something like that

http://xcell05.free.fr/


look at Morefunc and there is one called MCONCAT

that of course doesn't mean that MS shouldn't add something like this



--
Regards,

Peo Sjoblom

(No private emails please)


"yarp" wrote in message
...
The current syntax of CONCATENATE() is CONCATENATE (text1,text2,...).
Using it thus: CONCATENATE(A1:C3) is impossible. Of course, one should
think
of the order in which the cells are concatenated, since the case is
different
than that of SUM, AVERAGE or PRODUCT due to the concatenation's lack of
commutability.
In order not to mess up the existing function, I suggest a new function
with
this syntax:
CONCATRANGE(range, order1, order2, order3)
range - the range of cells to be concatenated
order1 - 0 or omitted for concatenating row after row, 1 for concatenating
column after column.
order2 - 0 or omitted for concatenating rows with the sheet's direction
(as
the column letters increase), 1 for concatenating rows in the reverse
order
(as the column letters decrease).
order3 - 0 or omitted for concatenating columns with the sheet's direction
(as the row numbers increase), 1 for concatenating columns in the reverse
order (as the row numbers decrease).
Example:
=CONCATRANGE(A1:B3, 1, 0, 1) is equivalent to =A2&A1&B2&B1&C2&C1.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow
this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...lic.excel.misc