Office
avenjan
这个作者很懒,什么都没留下…
展开
-
宏批量替换多个word指定文字
1、新建一个word文本,点击”开发工具“菜单下的”宏“按钮(如没有开发工具可点击”视图“下的宏按钮)2.输入名称后点击”创建“按钮3.输入如下代码:Sub CommandButton1_Click()Application.ScreenUpdating = False '关闭屏幕闪Dim myFile$, myPath$, i%, myDoc As Object, myAPP As Object, txt$, Re_txt$Set myAPP = New Word.App原创 2022-04-27 11:40:05 · 16275 阅读 · 25 评论 -
Excle IP地址排序
=TRIM(TEXT(LEFT(SUBSTITUTE(A996,".",REPT(" ",99)),100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),100,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),200,100),"000")&TEXT(MID(SUBSTITUTE(A996,".",REPT(" ",99)),300,100),"000"))原创 2020-10-22 19:10:16 · 382 阅读 · 0 评论