Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create range bar graph | Charts and Charting in Excel | |||
Match function...random search? | Excel Worksheet Functions | |||
How do I edit a Named Range using macro's | Excel Worksheet Functions | |||
Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
Define a range based on another named range | Excel Worksheet Functions |