在excel表格里怎样用find函数提取字符？
Excel中可以利用find函数提取含有某个字符的单元格。
软件版本：Office2007
方法如下：
1.提取A列中，含有字符1的单元格：
2.输入公式如下：
公式解释：先利用find函数从A列中提取1，然后利用isnumber函数对提取结果进行判断，如果提取到了，结果为True，提取不到结果为False，最后利用if函数设置返回值分别为原单元格和空值。
3.下拉填充得到结果：
绛旓細鍥句竴锛欱2鍗曞厓鏍鍏紡 锛=IF(ISNUMBER(FIND($A2,B$1)),$A2,"")鏍煎紡鏌勫彸鎷変笅鎷夊鍒跺叕寮 鍥句簩锛欱2鍗曞厓鏍煎叕寮忥細=IF(OR(ISNUMBER(FIND(MID($A2,ROW(INDIRECT("1:"&LEN($A2))),1),B$1))),"",$A2)鏁扮粍鍏紡锛宑trl+shift+enter缁勫悎閿粨鏉熻緭鍏 鏍煎紡鏌勫彸鎷変笅鎷夊鍒跺叕寮 ...
绛旓細锛圼涓锛夐変腑璇ユ锛氭柟妗1锛氭墦寮Microsoft Office Word2003鏂囨。锛屽湪鍏朵腑杈撳叆2611锛岀劧鍚庢寜alt + X浠ユ樉绀哄閫夋銆傚叾涓紝杈撳叆2612锛岀劧鍚庢寜alt + x锛屽彲浠ヨ緭鍑洪変腑鐨勬锛涜緭鍏2616锛岀劧鍚庢寜alt + x锛屽垯鍙互杈撳嚭鏂瑰舰榛戠偣锛屼緷姝ょ被鎺ㄣ傝В鍐虫柟妗2锛氬湪鍗曡瘝涓緭鍏ュぇ鍐欑殑鈥 R鈥濓紝鐒跺悗灏嗗瓧浣撴洿鏀逛负鈥 Wingdings2鈥濓紝...
绛旓細涓婄彮鍛ㄦ湡鏈濂藉垎鎴愪袱鍒楀啓銆傛寜鐓ф偍鐜板湪鐨勫啓娉曪紝澶勭悊璧锋潵鍏紡绋嶉暱銆傦紙姝ゅ浠ヤ笂鐝懆鏈熶负H5鍗曞厓鏍涓轰緥锛屽彲鑷璋冩暣锛=TEXT(RIGHT(H5,LEN(H5)-FIND("-",H5))-LEFT(H5,FIND("-",H5)-1)+(--LEFT(H5,FIND("-",H5)-1)>--RIGHT(H5,LEN(H5)-FIND("-",H5))),"hh:mm")...
绛旓細ALT+F11 绮樺笘涓嬮潰浠ｇ爜 杩愯姝ゅ畯鍗冲彲 Sub 鍒犻櫎鎸囧畾鍐呭琛()Dim fincell As Range On Error Resume Next Do With ActiveSheet.Rows("3:65536")Set findcell = .Cells.Find("鍒嗘瀽琛", LookAt:=xlPart)findcell.EntireRow.Delete Set findcell = .Cells.Find("鍦熷缓宸ョ▼", LookAt:=xlPart)findc...
绛旓細鏃犺涔嬪墠鏈夋病鏈夋媶鍒嗚繃绐楀彛銆備綘鍙互璇曡瘯涓嬮潰鐨勬祦绋嬶紝鐪嬭兘鍚︽垚鍔熴傚鏋滀笉鎴愬姛锛岄棶棰樺氨搴旇鍑鍦‥xcel涓婏紝鑰屼笉鏄綘鍘熸潵鐨勬枃浠躲傚弽涔嬩害鐒躲1.鏂板缓Excel鏂囦欢銆2.閫変腑B2鍗曞厓鏍锛屽伐鍏-鍐荤粨銆傝繖鏃讹紝绗竴鍒楀拰绗竴琛屽簲璇ユ槸澶勪簬鍐荤粨鐘舵併3.淇濆瓨閫鍑恒4.閲嶆柊鎵撳紑涔嬪悗锛屽喕缁撴晥鏋滃簲璇ヨ繕鏄湁鐨勩Fin....
绛旓細C2杈撳叆 =A2*B2/10000 涓嬫媺
绛旓細锛1锛夊缓绔嬩竴涓Excel琛锛岃〃澶存牸寮忓拰鍥句腑涓鑷达紝涔熷氨鏄鎴戜滑鎸囧畾鐨勮鏁拌寖鍥存槸B2寮濮嬬殑B鍒椼傦紙2锛鍦‥xcel鑿滃崟鏍忕殑绌虹櫧澶勫弻鍑伙紝閫夋嫨鑷畾涔夊揩閫熻闂伐鍏锋爮銆備粠鈥滄墍鏈夊懡浠も濅腑閫夋嫨鈥滄帶浠垛濓紝鐒跺悗娣诲姞銆佷繚瀛樸傦紙3锛夊埌杩欎竴姝ョ殑鏃跺欐爣棰樻爮鐨勪綅缃氨鍑虹幇浜嗕竴涓皬宸ュ叿绠辩殑鍥炬爣锛岀偣鍑诲畠鎻掑叆ActiveX鎺т欢锛岄夋嫨鎸夐挳銆...
绛旓細ALT+F11 绮樺笘涓嬮潰浠ｇ爜 杩愯姝ゅ畯鍗冲彲 Sub 鍒犻櫎鎸囧畾鍐呭琛()Dim fincell As Range On Error Resume Next Do With ActiveSheet.Rows("3:65536")Set findcell = .Cells.Find("鍒嗘瀽琛", LookAt:=xlPart)findcell.EntireRow.Delete Set findcell = .Cells.Find("鍦熷缓宸ョ▼", LookAt:=xlPart)find...
绛旓細鑷畾涔夊嚱鏁颁唬鐮侊細Function Fill(ByVal rng As Range) Dim str$, st1$, st2$, st3$, FinX%, i%, L%, k%, j%, ar() str = rng If str = "" Then Fill = "": Exit Function L = Len(rng) FinX = InStr(str, "-") Do Until IsNumeric(Mid(str, FinX ...
绛旓細鐢ㄣ愶紵in銆戞煡鎵撅紝鍦ㄢ滄煡鎵句笌鏇挎崲鈥濋〉闈紝鐐瑰嚮鈥滈夐」鈥濓紝鍕鹃夆鍗曞厓鏍鍖归厤鈥
