替换通配符为空

hai · 发表于 2008-2-17 04:23

本帖最后由爱疯于 2013-4-2 10:26 编辑 
<TABLE style="WIDTH: 54pt; BORDER-COLLAPSE: collapse" border=0 cellSpacing=0 cellPadding=0 width=72 xstr="">
<COLGROUP>
<COL style="WIDTH: 54pt" width=72></COL>
<COL></COL></COLGROUP>
<TBODY>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; WIDTH: 54pt; HEIGHT: 16.5pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8" height=22 width=72>
如题:
12*36??5*4</TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 16.5pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8" height=22>12*3*6??5*5</TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 16.5pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8" height=22>12*36??5*?6</TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 16.5pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8" height=22>12*36*??5*7</TD></TR>
<TR style="HEIGHT: 16.5pt" height=22>
<TD style="BORDER-BOTTOM-COLOR: #ece9d8; BACKGROUND-COLOR: transparent; BORDER-TOP-COLOR: #ece9d8; HEIGHT: 16.5pt; BORDER-RIGHT-COLOR: #ece9d8; BORDER-LEFT-COLOR: #ece9d8" height=22>12*36??5*8</TD></TR></TBODY></TABLE>

bcyj · 发表于 2008-2-17 04:53

=SUBSTITUTE(SUBSTITUTE(字符串,"*"," "),"?"," ")

[此贴子已经被作者于2008-2-17 4:54:47编辑过]

hai · 发表于 2008-2-17 04:58

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用bcyj在2008-2-17 4:53:00的发言： =SUBSTITUTE(SUBSTITUTE(字符串,"*"," "),"?"," ") </div>     请看清楚题意,是技巧题,不是函数题哦!

bcyj · 发表于 2008-2-17 05:02

调出替换对话框，查找内容输入：~* 或 ~?替换内容输入空格，点击替换。

hai · 发表于 2008-2-17 05:05

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用bcyj在2008-2-17 5:02:00的发言： 调出替换对话框，查找内容输入：~* 或 ~?替换内容输入空格，点击替换。</div>    [em17]

hhzjxss · 发表于 2008-2-17 08:40

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用bcyj在2008-2-17 5:02:00的发言： SUBSTITUTE(SUBSTITUTE(字符串,"*"," "),"?"," ") 调出替换对话框，查找内容输入：~* 或 ~?替换内容输入空格，点击替换。</div> 你就差VBA方法没写了！干脆写上来吧！ [em07]

guideming · 发表于 2008-2-17 09:50

<div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用hhzjxss在2008-2-17 8:40:00的发言： <div class="msgheader">QUOTE:</div><div class="msgborder">以下是引用bcyj在2008-2-17 5:02:00的发言： SUBSTITUTE(SUBSTITUTE(字符串,"*"," "),"?"," ") 调出替换对话框，查找内容输入：~* 或 ~?替换内容输入空格，点击替换。</div> 你就差VBA方法没写了！干脆写上来吧！ [em07]</div>一定是位马甲吧 [em01]

千里马 · 发表于 2008-5-19 12:31

谢谢

dnnwgzb · 发表于 2008-5-19 22:59

又学了一招

xjhn1968 · 发表于 2008-5-19 23:08

学习

		自动登录	找回密码
密码			注册