整理會計常用範例速查表



教學用_正則表達應用()

REGEX函式使用請匯至Microsoft365雲端版









<html lang="en"><head><style>              .article-container {                width: 100%;                font-family: Microsoft JhengHei,Helvetica Neue,Helvetica,Arial,sans-serif;              }              ul, ol {                margin: 12px auto;                max-width: 740px;                color: #535150;                line-height: 1.8;                padding-left: 0px;              }              .graf--img {                display: table;                justify-content: center;                align-items: center;                text-align: center;                color: gray;                font-size: 14px;                letter-spacing: 0px;                margin: 10px auto 50px;                width: 100%;                position: relative;                clear: both;              }              .graf--img.center img {                width: 100%;                max-width: 740px;                margin: 10px auto 0px;                display: block;                margin: 0 auto;              }              .graf--img.full img {                width: 100%;              }              .captionTheme__wrapper {                width: 100%;                font-style: normal;                line-height: 22px;                font-size: 16px;                max-width: 600px;                margin-top: 8px;                display: inline-block;              }              .graf--img.full {                max-width: 100%;                margin: 40px 0px;                display: block;                margin: 0 auto;                align-items: center;              }              .graf--figure {                text-align: center;                color: gray;                font-style: italic;                font-size: 15px;                margin: 28px auto;                box-sizing: border-box;              }              .graf--figure iframe {                width: 100%;                max-width: 740px;                margin: 0 auto;              }              .graf--p {                font-size: 16px;                line-height: 1.8;                font-family: "Microsoft JhengHei fixed", "Helvetica Neue" ,"Microsoft JhengHei", Helvetica, "Segoe UI", Tahoma, Arial, sans-serif;                letter-spacing: 1px;                font-weight: 400;                max-width: 740px;                color: #535150;                text-align: left;              }              .graf--p > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--li > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--quotesSpecial > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--blockquote > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--h1 > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--h2 > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              .graf--h3 > a {                color: #00B3C6 !important;                text-decoration: none !important;              }              a.graf--mention {                color: #535150 !important;                text-decoration: underline !important;                font-weight: 700;              }              .graf--h2 {                font-size: 24px;                padding: 0;                max-width: 740px;                text-align: left;                letter-spacing: 1px;                font-weight: 700;                margin-top: 34px;                line-height: 1.5;              }              .graf--h3 {                font-size: 18px;                padding: 0;                max-width: 740px;                text-align: left;                letter-spacing: 1px;                font-weight: 700;                margin-top: 28px;                line-height: 1.5;              }              .graf--li {                font-size: 16px;                padding: 0px 0px 0px 4px;                font-weight: 400;                letter-spacing: 0px;                list-style-position: outside;                text-align:left;                margin-left: 24px;              }              .graf--hr {                width: 100%;                margin: 0px auto;                transform: translateY(-50%);                position: relative;                padding: 0px;                text-align: left;                max-width: 740px;                margin: 0 auto;              }              .graf--hr hr {                height: 0;              }              .graf--blockquote {                padding: 10px 0px 10px 16px;                font-size: 16px;                color: #7A7574;                letter-spacing: 1px;                margin: 28px 0px;                border-left: 4px solid #DDD9D8;                width: 100%;                max-width: 740px;                text-align: left;              }              .graf--quotesSpecial {                display: table;                color: #7A7574;                position: relative;                padding: 31.5px 40px;                text-align: center;                letter-spacing: 0px;                position: relative;                margin: 29px auto;                font-family: "Microsoft JhengHei fixed", "Helvetica Neue", "Microsoft JhengHei", Helvetica, "Segoe UI", Tahoma, Arial, sans-serif;                font-size: 16px;                -webkit-box-ordinal-group: 1;                -webkit-box-flex: 0;              }              .embed-wrapper {                max-width: 740px;                border: 1px solid #DDD9D8;                display: block;                padding: 12px;                border-radius: 8px;                margin: 12px 0px;                text-decoration: none !important;              }              .embed-title {                font-size: 16px;                font-weight: 700;                color: #535150;                margin-bottom: 8px;                text-align: left;                line-height: 1.5;                text-decoration: none !important;              }              .embed-description {                width: 100%;                font-size: 14px;                color: #7A7574;                line-height: 1.5;                max-height: 150px;                text-align: left;                overflow: hidden;                padding: 12px 0px;              }              .embed-url > a {                width: 100%;                font-size: 14px;                color: #141413 !important;                text-decoration: none !important;                line-height: 1.5;                text-align: left;              }                            .embed-thumbnail-wrapper {                padding-left: 12px;              }              .embed-thumbnail {                width:100px;                border-radius: 8px;              }              pre {                background: #F6F6F6;                border-radius: 8px;                padding: 16px;                font-size: 16px;                color: #535150;                line-height: 180%;                text-align: left;              }              .lexical__textBold {                font-weight: bold;              }              .lexical__textItalic {                font-style: italic;              }              .lexical__textUnderline {                text-decoration: underline;              }              .lexical__textStrikethrough {                text-decoration: line-through;              }              .lexical__textUnderlineStrikethrough {                text-decoration: underline line-through;              }              .lexical__textSubscript {                font-size: 0.8em;                vertical-align: sub;              }              .lexical__textSuperscript {                font-size: 0.8em;                vertical-align: super;              }              .lexical__textCode {                background-color: rgb(240, 242, 245);                padding: 1px 0.25rem;                font-family: Menlo, Consolas, Monaco, monospace;                font-size: 94%;              }            </style></head><body><div class="article-container"><h3 class="graf--h3" dir="ltr"><sub style="white-space: pre-wrap;"><span class="lexical__textSubscript">整理會計常用範例速查表</span></sub></h3><div class="graf--img center"><div class="lexical__imageWrapper"><img src="https://images.vocus.cc/d35f0540-a92f-4c21-b0bf-99674ca37686.png" data-src="https://resize-image.vocus.cc/resize?compression=6&norotation=true&url=https%3A%2F%2Fimages.vocus.cc%2Fd35f0540-a92f-4c21-b0bf-99674ca37686.png&width=740&sign=vLxsYkYmcOBQokpBfIHl0hE3QAicyLmpkywnvVDo9nw" class="lazy" data-loaded="false" data-original-src="https://images.vocus.cc/d35f0540-a92f-4c21-b0bf-99674ca37686.png" data-lowquality="false" data-width="1327" data-height="722" data-retry="0" onerror="Number(this.dataset.retry) > 4 ? this.src='/static/default-error-img.svg': (() => {this.src=this.dataset.originalSrc; this.dataset.retry = Number(this.dataset.retry)+1;})()" data-istopthreeimage="false" alt="raw-image"></div><div></div></div><div class="graf--img center"><div class="lexical__imageWrapper"><img src="https://images.vocus.cc/57662ff7-d2e0-4592-9b49-493f6525bdff.png" data-src="https://resize-image.vocus.cc/resize?compression=6&norotation=true&url=https%3A%2F%2Fimages.vocus.cc%2F57662ff7-d2e0-4592-9b49-493f6525bdff.png&width=740&sign=etuqVN5fsuu3NV7KaN4NMA5Ty0O3xzkQFxGrWKu8Bkw" class="lazy" data-loaded="false" data-original-src="https://images.vocus.cc/57662ff7-d2e0-4592-9b49-493f6525bdff.png" data-lowquality="false" data-width="1319" data-height="341" data-retry="0" onerror="Number(this.dataset.retry) > 4 ? this.src='/static/default-error-img.svg': (() => {this.src=this.dataset.originalSrc; this.dataset.retry = Number(this.dataset.retry)+1;})()" data-istopthreeimage="false" alt="raw-image"></div><div></div></div><p class="graf--p" dir="ltr"><br></p><p class="graf--p" dir="ltr"><a href="https://docs.google.com/spreadsheets/d/1eVplPRByQgbT0GxU7GXANfGktfalWpKz/edit?usp=drive_link&ouid=100375430087336688581&rtpof=true&sd=true" target="_blank" rel="noreferrer noopener"><span style="white-space: pre-wrap;">教學用_正則表達應用()</span></a><br><br><br><br><br><br><br><br></p></div></body></html>

以行動支持創作者！付費即可解鎖

學習

《結帳自由系列前導文｜會計人 RPA 》

會計人為什麼要學正則表達式？

2025  vocus 推出最受矚目的活動之一——《開箱你的美好生活》，我們跟著創作者一起「開箱」各種故事、景點、餐廳、超值好物⋯⋯甚至那些讓人會心一笑的生活小廢物；這次活動不僅送出了許多獎勵，也反映了「內容有價」——創作不只是分享、紀錄，也能用各種不同形式變現、帶來實際收入。

方格子 vocus 官方沙龍

2025 下半場，蝦皮分潤計畫 x vocus 陪你回顧上半年的美好開箱！

嗨！歡迎來到 vocus

vocus 方格子是台灣最大的內容創作與知識變現平台，並且計畫持續拓展東南亞等等國際市場。我們致力於打造讓創作者能夠自由發表、累積影響力並獲得實質收益的創作生態圈！「創作至上」是我們的核心價值，我們致力於透過平台功能與服務，賦予創作者更多的可能。

vocus 平台匯聚了

徵才：社群與內容行銷專員 (Community & Marketing Specialist)

致力於交流【VBA｜RPA自動化｜會計實務】的學習社群。

會計自動化研究社

技術力養成所

Excel自動化

RPA自動化

結帳自由系列

檔案下載區

會計

給會計人的Excel正則表達式小抄

<h3 class="lexical__h3" dir="ltr"><sub style="white-space: pre-wrap;"><span class="lexical__textSubscript">整理會計常用範例速查表</span></sub></h3><div class="lexical__image center"><div class="lexical__imageWrapper"><img src="https://resize-image.vocus.cc/resize?compression=6&amp;norotation=true&amp;url=https%3A%2F%2Fimages.vocus.cc%2Fd35f0540-a92f-4c21-b0bf-99674ca37686.png&amp;width=740&amp;sign=vLxsYkYmcOBQokpBfIHl0hE3QAicyLmpkywnvVDo9nw" fetchpriority="high" data-src="https://resize-image.vocus.cc/resize?compression=6&amp;norotation=true&amp;url=https%3A%2F%2Fimages.vocus.cc%2Fd35f0540-a92f-4c21-b0bf-99674ca37686.png&amp;width=740&amp;sign=vLxsYkYmcOBQokpBfIHl0hE3QAicyLmpkywnvVDo9nw" data-loaded="true" data-original-src="https://images.vocus.cc/d35f0540-a92f-4c21-b0bf-99674ca37686.png" data-lowquality="false" data-width="1327" data-height="722" data-retry="0" onerror="Number(this.dataset.retry) > 4 ? this.src='/static/default-error-img.svg': (() => {this.src=this.dataset.originalSrc; this.dataset.retry = Number(this.dataset.retry)+1;})()" data-istopthreeimage="true" alt="raw-image"></div><div></div></div><div class="lexical__image center"><div class="lexical__imageWrapper"><img src="https://resize-image.vocus.cc/resize?compression=6&amp;norotation=true&amp;url=https%3A%2F%2Fimages.vocus.cc%2F57662ff7-d2e0-4592-9b49-493f6525bdff.png&amp;width=740&amp;sign=etuqVN5fsuu3NV7KaN4NMA5Ty0O3xzkQFxGrWKu8Bkw" fetchpriority="high" data-src="https://resize-image.vocus.cc/resize?compression=6&amp;norotation=true&amp;url=https%3A%2F%2Fimages.vocus.cc%2F57662ff7-d2e0-4592-9b49-493f6525bdff.png&amp;width=740&amp;sign=etuqVN5fsuu3NV7KaN4NMA5Ty0O3xzkQFxGrWKu8Bkw" data-loaded="true" data-original-src="https://images.vocus.cc/57662ff7-d2e0-4592-9b49-493f6525bdff.png" data-lowquality="false" data-width="1319" data-height="341" data-retry="0" onerror="Number(this.dataset.retry) > 4 ? this.src='/static/default-error-img.svg': (() => {this.src=this.dataset.originalSrc; this.dataset.retry = Number(this.dataset.retry)+1;})()" data-istopthreeimage="true" alt="raw-image"></div><div></div></div><p class="lexical__paragraph" dir="ltr"><br></p><p class="lexical__paragraph" dir="ltr"><a href="https://docs.google.com/spreadsheets/d/1eVplPRByQgbT0GxU7GXANfGktfalWpKz/edit?usp=drive_link&amp;ouid=100375430087336688581&amp;rtpof=true&amp;sd=true" target="_blank" rel="noreferrer noopener"><span style="white-space: pre-wrap;">教學用_正則表達應用()</span></a><br><br><br><br><br><br><br><br></p>