EXCEL偺substitute偱儚僀儖僪僇乕僪偑巊偊側偄両丠戙傢傝偺曽朄峫偊傑偟偨両

EXCEL偺抲姺娭悢偱儚僀儖僪僇乕僪偑巊偊側偄両丠
substitute傗replace側偳偺抲姺娭悢偱儚僀儖僪僇乕僪偑巊偄偨偄偺偵乧

EXCEL偵偮偄偰偄傞抲姺婡擻偱偁傟偽儚僀儖僪僇乕僪
偑巊偊傑偡偑丄娭悢偱峴偄偨偄偲偒傕偁傝傑偡傛偹丅

抲姺娭悢偲偄偊偽
substitute
replace
偑偁傝傑偡偑丄傗偼傝儚僀儖僪僇乕僪偼
巊偊傑偣傫丅

巹傕側傫偲偐偟偰娭悢偩偗偱暥帤楍偺拪弌傪峴偭偰
偒傑偟偨偺偱丄崱夞偼偦偺曽朄傪偛徯夘偟偨偄偲
巚偄傑偡丅

尩枾偵偼儚僀儖僪僇乕僪傎偳偺棙曋惈偼側偄偺偱偡偑
嶲峫偵側傞曽偑偄傟偽婐偟偄偱偡丅

怓乆側暥帤楍娭悢偺慻傒崌傢偣偱抲姺傪峴偍偆

偦偙偱丄暥帤楍専嶕偺娭悢側偳偲慻傒崌傢偣偰
儚僀儖僪僇乕僪偲嬤偟偄寢壥偑弌偣傞傛偆偵
偟偰傒傑偟偨丅

EXCEL 抲姺娭悢儚僀儖僪僇乕僪

尦偺暥帤楍乽偁-偄偆-偊偍-偐-偒乿
抲姺偵巊偆暥帤乽-乿

椺侾屻傠偺暥帤楍傪慡偰偗偡 (-*)
=LEFT($A$5,FIND($A$2,$A$5)-1)

椺俀 N斣栚埲崀傪徚偡
=LEFT($A$5,FIND("冃冇",SUBSTITUTE($A$5,$A$2,"冃冇",3))-1)
仸,3偺悢帤傪曄偊傞偙偲偱壗斣栚偐傪曄偊傞偙偲偑壜擻偱偡丅

椺俁 N斣栚埲慜傪徚偡
=MID($A$5,FIND("冃冇",SUBSTITUTE($A$5,$A$2,"冃冇",3))+1,LEN($A$5)) 仸,3偺悢帤傪曄偊傞偙偲偱壗斣栚偐傪曄偊傞偙偲偑壜擻偱偡丅

椺係慜偺暥帤楍傪徚偡 (*-)
=MID($A$5,FIND("冃冇",SUBSTITUTE($A$5,$A$2,"冃冇",LEN($A$5)-LEN(SUBSTITUTE($A$5,$A$2,""))))+1,LEN($A$5))

奆偝傫偺僯乕僘偵偁偭偰偄側偐偭偨傜偡偄傑偣傫丅丅
崱夞偼乽EXCEL substitute偱儚僀儖僪僇乕僪偑巊偊側偄乿偵偮偄偰
戙懼埬偺偛徯夘偵側傝傑偟偨丅
僼傽僀儖傕梸偟偄曽偼僟僂儞儘乕僪偟偰偔偩偝偄
excel_tikan_wildcard.zip

娭楢僐儞僥儞僣

EXCEL偱偍崲傝偺曽傊

摉僒僀僩偱偼奆偝傑偑EXCEL嶌嬈偱峴偒媗偭偨栤戣傪夝寛偡傞傋偔墹摴偺僥僋僯僢僋偐傜偪傚偭偲摿庩側僥僋僯僢僋傑偱條乆側拞乣忋媺媄丒僾僠僥僋僯僢僋傪岞奐偟丄彮偟偱傕奆條偺嬈柋岠棪夵慞偵栶棫偰偰偄偨偩偗傟偽偲巚偄丄僱僞傪傑偲傔偰偄傑偡丅

EXCEL偺嶌嬈偱擸傒丒偍崲傝偛偲偼偁傝傑偣傫偐丠
廤寁偵帪娫偑偐偐傝夁偓丅岠棪壔傪偟偨偄丅側偳側偳擔崰偐傜暠摤偟偰偄傞偁側偨偵彮偟偱傕嶲峫偵側傞忣曬傪梌偊傞偙偲偑弌棃傟偽岾偄偱偡丅

幙栤丒憡択側偳傕庴偗晅偗偰偍傝傑偡偑丄嵟嬤朲偟偔偰曉帠偑抶傟偰偟傑偄傑偡丅丅丅
僒僀僩撪偺撪梕偵偮偄偰偺偛幙栤偼桪愭揑偵庴偗晅偗偰偍傝傑偡偑丄偦傟埲奜偺偛憡択側偳偼偍抐傝偡傞偙偲傕偁傝傑偡偺偱偛椆彸偔偩偝偄丅
仸僒儞僾儖偺僄僋僙儖僼傽僀儖側偳揧晅偟偰偄偨偩偔偲夞摎傕僗儉乕僘偵峴偊傞応崌偑懡偄偱偡丅

儕儞僋

EXCEL曋棙媄傑偲傔

僂僃僽儅乕働僢僞乕OKB偺僂僃僽儅乕働僥傿儞僌僗僉儖廤

EXCEL偺substitute偱儚僀儖僪僇乕僪偑巊偊側偄両丠戙傢傝偺曽朄峫偊傑偟偨両