How do I concatenate a range of cells in Excel?
For example: I have a column with many cells containing text information and would like to concatenate them, but when using the concatenate function error occurs, being necessary to select one by one of the cells.
The =CONCATENAR(B2:B48) function in this way does not work, so you need to rewrite it as follows: =CONCATENAR(B2;B3;B4; ... B48) .
In search I found suggestion to use a function called unirtext, but it is not recognized.
How do I concatenate a range of cells in Excel?
For example: I have a column with many cells containing text information and would like to concatenate them, but when using the concatenate function error occurs, being necessary to select one by one of the cells.
The TRANSPOR() function in this way does not work, so you need to rewrite it as follows: &" " .
In search I found suggestion to use a function called unirtext, but it is not recognized.
If you select cells in a column, he does not know concatenate even.
You have to cross the "column" to work:
In the target cell, start typing the function CONCAT() %
=TRANSPOR()
Select range ,
=TRANSPOR(B2:B48)
Add %code% at the end of the range
=TRANSPOR(B2:B48&" ")
Select the whole function; this part:
TRANSPOR(B2:B48&" ")
Press the F9 key on the keyboard; it will convert the range into a list. Finish by putting the %code% function around the list,
=CONCAT({"O ", "rato ", "roeu ", ...})
Source: here
If you have Excel 2016, you can use the %code% formula like this:
=TRANSPOR()
here the documentation
If you have Excel 2016, you can use the UNIRTEXTO formula like this:
=UNIRTEXTO(" ",0,B2:B48)
here the documentation