http://valley.egloos.com/tag/find find ko Thu, 24 May 2012 18:06:59 +0900 Egloos http://always19.egloos.com/2867952 http://always19.egloos.com/2867952 Thu, 24 May 2012 18:06:59 +0900 http://anti1346.egloos.com/5094861 http://anti1346.egloos.com/5094861 Tue, 27 Mar 2012 11:05:33 +0900 http://kwontaeun.egloos.com/2919251 http://kwontaeun.egloos.com/2919251 Wed, 14 Mar 2012 23:10:21 +0900 http://leopit.egloos.com/2285863 http://leopit.egloos.com/2285863 Thu, 01 Mar 2012 22:07:42 +0900 http://IS10.egloos.com/494325 http://IS10.egloos.com/494325 Tue, 21 Feb 2012 05:06:04 +0900 http://pangru.egloos.com/1073960 http://pangru.egloos.com/1073960 Wed, 28 Dec 2011 12:37:54 +0900 http://genes1s.egloos.com/2817778 http://genes1s.egloos.com/2817778 Tue, 08 Nov 2011 17:32:35 +0900 http://mnjp.egloos.com/229210 http://mnjp.egloos.com/229210 Fri, 28 Oct 2011 18:00:01 +0900 http://katalog.egloos.com/4637947 http://katalog.egloos.com/4637947 Mon, 24 Oct 2011 16:26:06 +0900 http://katalog.egloos.com/4636851 http://katalog.egloos.com/4636851 Fri, 21 Oct 2011 17:20:24 +0900 http://katalog.egloos.com/4636849 http://katalog.egloos.com/4636849 Fri, 21 Oct 2011 17:16:59 +0900 http://ascendo.egloos.com/2785645 http://ascendo.egloos.com/2785645 Wed, 10 Aug 2011 00:00:57 +0900 http://tmt313.egloos.com/2182554 http://tmt313.egloos.com/2182554 find함수로 단어나 문장을 뜯어내기(추출) 예를들어 A1셀 안에, <title><![CDATA[ 아이폰4 갤럭시S2 둘중에 뭐가 좋을가요?? ]]></title> 이라는 문장이 들어있고, 이런식의 데이터가 줄줄이 계속된다면, "아이폰4 갤럭시S2 둘중에 뭐가 좋을가요??" 이라는 문장만 뜯어내고자 하는경우, find함수로 " [" 의 위치값와 " ]"의 위치값을 찾아내어 mid함수로 그 사이에 있는 문자열을 뜯어내면 된다. "[ "의 위치를 알아내려면, 다음의 함수를, =FIND("[ ",A1)"[ "의 위치를 알아내려면, 다음의 함수를, =FIND(" ]",A1) mid함수를 응용하여 그 둘 사이의 글자들을 뜯어내려면, 다음처럼, =MID(A ]]> Tue, 09 Aug 2011 15:24:52 +0900 http://hyunki1019.egloos.com/20276 http://hyunki1019.egloos.com/20276 Thu, 14 Jul 2011 14:38:00 +0900 http://mcchae.egloos.com/10686522 http://mcchae.egloos.com/10686522 Fri, 01 Apr 2011 20:04:40 +0900