엑셀 중복된값 제거시 셀은 그대로 두고 안에 내용만 삭제할수있나요?

<div id="qna_detail_question" class="qna_detail_question" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><div class="end_question _end_wrap_box" style="margin: 0px; padding: 0px; width: 679px; background: url("http://static.naver.net/kin/09renewal/bg_end_q.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="question" alt="질문" style="margin: 33px 0px 0px 25px; padding: 0px; border: 0px; width: 47px; height: 47px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 class="_endTitleText" style="margin: 0px; padding-top: 0px; padding-right: 0px; padding-bottom: 4px !important; padding-left: 0px; width: 410px; color: rgb(16, 16, 16); font-size: 16px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;">엑셀 중복된값 제거시 셀은 그대로 두고 안에 내용만 삭제할수있나요?</h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dt style="margin: 0px 3px 0px 0px; padding: 5px 8px 5px 24px; display: inline; color: rgb(66, 66, 66); font-size: 11px; background: url("http://static.naver.net/kin/09renewal/ico_q_sta.gif") 1px 0px no-repeat;">hwan**** </dt><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">질문 35건 질문마감률</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">100%</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.03.27. 09:30</dd></dl></div><div class="recom_q" style="margin: 0px; padding: 27px 0px 0px; float: right; width: 175px; border-left-width: 1px; border-left-style: solid; border-left-color: rgb(233, 234, 228); text-align: center;"><div class="lvarea" style="margin: 0px; padding: 5px 0px 4px;"><strong class="blind" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; position: absolute; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 21px; line-height: 21px; display: inline-block; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;"></strong><strong class="_kinupPoint" style="margin: 0px 0px 0px -6px; padding: 0px 0px 0px 18px; display: inline-block; overflow: hidden; font-size: 21px; font-family: Tahoma, Helvetica; color: rgb(245, 72, 18); line-height: 21px; background: url("http://static.naver.net/kin/09renewal/sp_recm.gif") -150px 0px no-repeat;">2</strong></div><dl style="margin: 0px; padding: 4px 0px 0px; font-size: 11px;"><dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">답변</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);"><strong style="margin: 0px 4px 0px 0px; padding: 0px 9px 0px 0px; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 100% 0px no-repeat;">1</strong></dd> <dt style="margin: 0px; padding: 0px; display: inline; color: rgb(120, 120, 120); letter-spacing: -1px;">조회</dt> <dd style="margin: 0px; padding: 0px; display: inline; color: rgb(66, 66, 66);">51</dd></dl></div></div><div id="contents_layer_0" style="margin: 0px; padding: 0px;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="_endContentsText" style="margin: 0px; padding: 0px;"><p>엑셀에서 중복된값제거하면 셀안에 데이터와 셀이 같이 삭제되는데</p><p><br style="margin: 0px; padding: 0px;"></p><p>셀은 그대로 유지가되고 그안에 값만 제거 되게 할수 있나요?</p><p><br style="margin: 0px; padding: 0px;"></p><p><br style="margin: 0px; padding: 0px;"></p><font color="#000000" style="margin: 0px; padding: 0px;"></font><table border="0" width="600px" height="40" cellspacing="1" cellpadding="0" bgcolor="#B7BBB5" style="margin: 0px; padding: 0px;"><tbody style="margin: 0px; padding: 0px;"><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td width="201px" style="margin: 0px; padding: 0px;">데이터<br style="margin: 0px; padding: 0px;"></td><td width="201px" style="margin: 0px; padding: 0px;"> 일반적인 중복값 제거</td><td width="201px" style="margin: 0px; padding: 0px;"> 원하는 방식</td></tr><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td style="margin: 0px; padding: 0px;"> 1</td><td style="margin: 0px; padding: 0px;"> 1</td><td style="margin: 0px; padding: 0px;"> 1</td></tr><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td style="margin: 0px; padding: 0px;"> 1</td><td style="margin: 0px; padding: 0px;"> 2</td><td style="margin: 0px; padding: 0px;"> </td></tr><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td style="margin: 0px; padding: 0px;"> 2</td><td style="margin: 0px; padding: 0px;"> 3</td><td style="margin: 0px; padding: 0px;"> 2</td></tr><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td style="margin: 0px; padding: 0px;"> 2</td><td style="margin: 0px; padding: 0px;"> </td><td style="margin: 0px; padding: 0px;"> </td></tr><tr bgcolor="#FFFFFF" style="margin: 0px; padding: 0px;"><td style="margin: 0px; padding: 0px;"> 3</td><td style="margin: 0px; padding: 0px;"> </td><td style="margin: 0px; padding: 0px;"> 3</td></tr></tbody></table><br style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"><p><br style="margin: 0px; padding: 0px;"></p></div></div><div id="qna_detail_question_commentAndMenu" style="margin: 0px; padding: 0px;"><div class="end_qna_link _end_qna_link" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 10;"><div class="recom_a" style="margin: 0px 0px 0px 28px; padding: 0px;"><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1#" id="cmtstr_0" class="btn _write_opinion _param('kin,10202,248870632,0,KxtrKAtdKqMwFovrFZvZFA2/FqgrKqUGpzkRD4vGF029E0-HLvpK3dw6xt==') " style="margin: 0px 10px 0px 0px; padding: 9px 0px 7px; display: inline-block; overflow: hidden; width: 88px; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(0, 0, 0); font-weight: bold;">의견 쓰기</a></div><div class="btn_wrap" style="margin: 0px; padding: 0px; display: inline-block; position: relative; float: left;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1#" class="btn opinion _metoo_wonder disable _param('10202,248870632,PC') _clickcode:end.metoo" style="margin: 0px 10px 0px 0px; padding: 9px 12px 7px; float: left; display: inline-block; overflow: hidden; width: auto; height: 14px; border-top-width: 1px; border-right-width: 1px; border-left-width: 1px; border-style: solid; border-color: rgb(208, 208, 208); text-align: center; color: rgb(177, 177, 177); font-weight: bold; cursor: default;">나도 궁금해요<span style="margin: 0px; padding: 0px; color: rgb(235, 51, 51); font-size: 14px; vertical-align: bottom;"></span></a></div></div><ul class="etc" style="margin-top: 0px; margin-right: 0px; margin-bottom: 0px; padding: 0px 18px 0px 0px; position: absolute; bottom: 41px; right: 0px;"><li class="first" style="margin: 0px; padding: 0px 9px; list-style: none; position: relative; display: inline; float: left; background: none;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1#" class="_statement _ros _param('question,10202,248870632,KxtrKAtdKqMwFovrFZvZFA2/FqgrKqUGpzkRD4vGF029E0-HLvpK3dw6xt==')" style="margin: 0px; padding: 0px; display: inline-block; color: rgb(44, 44, 44); line-height: 16px;">신고</a></li></ul></div><div class="_wrap_iframe" style="margin: 0px; padding: 0px;"></div></div><div class="end_q_bottom" style="margin: -9px 0px 0px; padding: 0px 0px 35px; clear: both; width: 679px; border-top-width: 1px; border-top-style: solid; border-top-color: rgb(243, 243, 243);"><p style="margin-top: 31px; padding-left: 44px; position: relative; float: left; color: rgb(118, 118, 118); line-height: 19px;"><span class="ico" style="margin: 0px; padding: 0px; display: block; position: absolute; top: 3px; left: 28px; width: 12px; height: 12px; background: url("http://static.naver.net/kin/09renewal/bg_sprite_ico_140811.gif") 0px -1740px no-repeat;"></span>질문자 채택된 경우, <span style="margin: 0px; padding: 0px; color: rgb(27, 143, 0);">추가 답변 등록이 불가</span>합니다.</p></div></div></div></div><div id="qna_detail_answerList_best" class="qna_detail_answerList" style="margin: 0px; padding: 0px; color: rgb(0, 0, 0); font-family: 돋움, Dotum, 굴림, Gulim, Helvetica, 'Apple SD Gothic Neo', 새굴림, 'New Gulim', sans-serif; line-height: 14px;"><a name="answer1" style="margin: 0px; padding: 0px;"><span class="blind a_initial" style="margin: 0px; padding: 0px; position: relative; top: 0px; left: 0px; width: 0px; height: 0px; overflow: hidden; visibility: hidden; font-size: 0px; line-height: 0;"></span></a><div class="end_answer _end_wrap_box" style="margin: 0px; padding: 0px; position: relative; width: 679px; border-top-width: 1px !important; border-top-style: solid !important; border-top-color: rgb(197, 197, 197) !important; background: url("http://static.naver.net/kin/09renewal/bg_end_a.gif") repeat-x;"><div class="end_tit" style="margin: 0px; padding: 0px 0px 35px; position: relative; clear: both; width: 679px; z-index: 5 !important;"><div class="tit_ico" style="margin: 0px; padding: 0px 7px 0px 0px; float: left;"><img src="https://img1.daumcdn.net/relay/cafe/original/?fname=http%3A%2F%2Fstatic.naver.net%2Fkin%2F09renewal%2Fblank.gif" width="1" height="1" class="choose_q" alt="질문자 채택" style="margin: -1px 0px -16px 12px; padding: 0px; border: 0px; width: 73px; height: 90px; background: url("http://static.naver.com/kin/09renewal/bg_sprite_endico_141222.gif") 0px -700px no-repeat;"></div><div class="tit_cont _endTitle" style="margin: 0px; padding: 34px 0px 0px; float: left;"><h3 style="margin: 0px; padding: 0px 0px 5px; width: 410px; color: rgb(16, 16, 16); font-size: 14px; line-height: 21px; letter-spacing: -1px; word-break: break-all; word-wrap: break-word;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1#" class="_user_id _popup" style="margin: 0px; padding: 0px;"><span style="margin: 0px; padding: 0px; color: rgb(38, 142, 0);">합격다드림(demzi)</span></a>님의 답변입니다.</h3><dl style="margin: 0px; padding: 0px; overflow: hidden; width: 420px; line-height: 19px;"><dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;"><span style="margin: 0px; padding: 0px; color: rgb(121, 121, 121); letter-spacing: -1px;">채택답변수</span><span style="margin: 0px -1px 0px 4px; padding: 0px; color: rgb(44, 95, 153);">61</span></dd> <dd class="date" style="margin: 0px 5px 0px -8px; padding: 0px 8px; display: inline; color: rgb(144, 144, 144); font-size: 11px; letter-spacing: 0px; white-space: nowrap; zoom: 1; background: url("http://static.naver.net/kin/09renewal/line_v7.gif") 0px 0px no-repeat;">2016.03.27. 10:05</dd></dl></div></div><div class="end_a_thanks" style="margin: 0px auto 20px; padding: 0px; clear: both; width: 623px; overflow: hidden; border: 1px solid rgb(240, 240, 240); background: rgb(248, 248, 248);"><h4 style="margin: 0px; padding: 18px 0px 0px 15px; float: left; width: 75px; color: rgb(38, 142, 0); letter-spacing: -1px;">질문자 인사</h4><p style="padding-top: 15px; padding-bottom: 15px; float: left; width: 500px; color: rgb(48, 48, 48); line-height: 19px;">감사합니다 고수님의 지식에 10년 묶은 변비가 내려가듯 정말 친절한 답변 감사드립니다.</p></div><div id="contents_layer_1" style="margin: 0px; padding: 0px; position: relative; z-index: 0;"><div class="end_content _endContents" style="margin: 0px auto; padding: 0px 0px 54px; width: 623px; overflow: hidden; color: rgb(64, 64, 64); font-family: gulim, sans-serif; font-size: 13px; line-height: 1.7; word-break: break-all; word-wrap: break-word;"><div class="_endContentsText" style="margin: 0px; padding: 0px;"><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div>원하는 데이터가 A2부터 있다고 가정하고<div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">=IF(COUNTIF($A$2:A2,A2)=1,A2,"")</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">이렇게 넣어보시길 바랍니다</div><div style="margin: 0px; padding: 0px;">자료 첨부합니다</div><div style="margin: 0px; padding: 0px;"><br style="margin: 0px; padding: 0px;"></div><div style="margin: 0px; padding: 0px;">-균쌤</div></div><div class="end_attach_file" style="margin: 0px; padding: 4px 0px 0px; clear: both; font-size: 12px; line-height: 14px; font-family: 돋움, Dotum, 'Apple SD Gothic Neo', sans-serif, Helvetica;"><div class="atch_wrap" id="_answer1_attach" style="margin: 0px; padding: 0px;"><p class="lst_file " style="margin-top: 3px; padding: 7px 8px 6px; overflow: hidden; position: relative; border: 1px solid rgb(230, 230, 230); background-color: rgb(255, 255, 255);"><span class="file_name" title="Book1.xlsx" style="margin: 0px; padding: 0px;"><span class="ic_file" style="margin: 1px 4px 0px 0px; padding: 0px; display: inline-block; overflow: hidden; width: 7px; height: 10px; font-size: 0px; line-height: 100px; vertical-align: top; white-space: nowrap; background: url("http://static.naver.net/kin/09renewal/sp_atch_btn_v1.gif") -56px -67px no-repeat;"></span><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1" class="txt _lst_file _param('_answer1,10202,248870632,1,0')" style="margin: 0px; padding: 0px; display: inline-block; overflow: hidden; max-width: 450px; white-space: nowrap; text-overflow: ellipsis; word-wrap: normal; color: rgb(77, 77, 77); vertical-align: top;">Book1.xlsx</a></span><span class="file_down" style="margin: 0px; padding: 0px; position: absolute; right: 8px; font-size: 11px; letter-spacing: -1px;"><a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1" class="_lst_file _param('_answer1,10202,248870632,1,0')" style="margin: 0px; padding: 0px; color: rgb(102, 102, 102);">내PC 저장</a> <span class="bar" style="margin: -2px 6px 0px; padding: 0px; display: inline-block; width: 1px; height: 10px; vertical-align: middle; background-color: rgb(229, 229, 229);"></span> <a href="http://kin.naver.com/qna/detail.nhn?d1id=1&dirId=10202&docId=248870632&page=1" class="ndrive _file _downloadFileToNdrive _param('_answer1,10202,248870632,1,0,Book1.xlsx')" style="margin: 0px; padding: 0px; color: rgb(102, 102, 102);">네이버 클라우드 저장</a></span></p></div></div></div></div></div></div><p><br></p>