엑셀 셀내 줄바꿈 처리방법

CONCATENATE함수를 이용하여 줄바꿈부분에 “CHAR(10)” 처리

예제) =CONCATENATE(“A1″&CHAR(10)&”B1″&CHAR(10)&”C1”)

에디터 확인결과) 

A1

B1

C1

Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments