filmov
tv
Excel: Combine Text from Multiple Cells into One Cell (Concatenate)
Показать описание
Program: Excel 2010
Instructions:
Formula 1
=concatenate(firstcellreference,secondcellreference)
for example, =concatenate(A2,B2)
Result: combined texts from cells without space in between
Formula 2
=concatenate(firstcellreference," ",secondcellreference)
for example, =concatenate(A2," ",B2)
Result: combined texts from cells with space in between
Instructions:
Formula 1
=concatenate(firstcellreference,secondcellreference)
for example, =concatenate(A2,B2)
Result: combined texts from cells without space in between
Formula 2
=concatenate(firstcellreference," ",secondcellreference)
for example, =concatenate(A2," ",B2)
Result: combined texts from cells with space in between