- 엑셀 2개 계산 결과를 1개의 칼럼 셀에 묶어서 표시하는 방법

 

* 방법

& 로 묶으면 된다

 

 

* 사용 예

    - A1 과 A2 셀의 내용을 묶어서 A3에 표시

=A1&" "&A2

 

 

    - 계산 결과 묶기

=SUM(A1:A10)&" "&SUM(B2:B20)





//--------------------------------------------

Combine text from two or more cells into one cell

https://support.microsoft.com/en-us/office/combine-text-from-two-or-more-cells-into-one-cell-81ba0946-ce78-42ed-b3c3-21340eb164a6



Posted by cd cd1

댓글을 달아 주세요