Concatenate ranges

Modified on Tue, 18 Oct 2022 at 11:11 AM

Using Power-user you concatenate ranges in Excel. This can be useful to merge the content of different columns or rows into a single column or row. 

One typical use case when concatenation is needed is for preparing .csv files.

With Power-user you can concatenate your Excel data with several options, as shown below:

Power-user add-in l Concatenate ranges of data in Excel

To concatenate a range:

  • Click Concatenate from the Excel ribbon
  • Select the range you would like to concatenate
  • Select the option of your choice:
    • Concatenate Columns: a new column will be created at the right of your selection, containing the concatenation of all columns from your selection.
    • Concatenate Rows: a new row will be created at the bottom of your selection, containing the concatenation of all rows from your selection.
    • Concatenate Cells: a new cell will be added next to your selection, containing the concatenation of all cells in your selection (both columns and rows).
  • Select the separator to use for the concatenation: you can choose between different separators, such as a semi column, comma, dash, space, tabulation, line break and more. You can also type your own separator if you need something more custom.
  • Check Ignore empty cells if it's relevant in your context.
  • By default the concatenation is made as formulas, using the Excel TEXTJOIN function. But you can uncheck Concatenate as formulas if you want to have only values in the resulting range.
  • Click OK to validate.

Power-user add-in for Excel l Concatenate ranges

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select atleast one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article