整理會計常用範例速查表



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

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 》

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

雙11於許多人而言，不只是單純的折扣狂歡，更是行事曆裡預定的，對美好生活的憧憬。 錢錢沒有不見，它變成了快樂，跟讓臥房、辦公桌、每天早晨的咖啡香升級的樣子！
這次格編突擊辦公室，也邀請 vocus「野格團」創作者分享掀開蝦皮購物車的簾幕，「加入購物車」的瞬間，藏著哪些靈感，或是對美好生活的想像？


方格子 vocus 官方沙龍

線上街訪直擊！雙 11 購物車大公開！

雙11購物節準備開跑，蝦皮推出超多優惠，與你分享實際入手的收納好物，包括貨櫃收納箱、真空收納袋、可站立筆袋等，並分享如何利用蝦皮分潤計畫，一邊購物一邊賺取額外收入，讓你買得開心、賺得也開心！

Chloe小窩

租屋整理控必看 | 雙11收納好物開箱 × 蝦皮分潤計畫

分享個人在新家裝潢後，精選 5 款蝦皮上的實用家居好物，包含客製化層架、MIT 地毯、沙發邊桌、分類垃圾桶及寵物碗架，從尺寸、功能到價格都符合需求，並提供詳細開箱心得與購買建議。

邊境牧羊犬的觀察筆記

開箱｜我為新家買的 5 樣家居好物！蝦皮購物實用選品

Excel自動化

結帳自由系列

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

會計自動化研究社

RPA 程式思維入門

技術力養成所

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>