{"id":1351,"date":"2026-03-27T07:04:23","date_gmt":"2026-03-27T07:04:23","guid":{"rendered":"https:\/\/yuanstore.tw\/e-learning\/?p=1351"},"modified":"2026-04-08T14:24:37","modified_gmt":"2026-04-08T14:24:37","slug":"excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8","status":"publish","type":"post","link":"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/","title":{"rendered":"Excel04 &#8211; \u6587\u5b57\u5e38\u7528\u51fd\u6578"},"content":{"rendered":"\n<div class=\"wp-block-uagb-container uagb-block-1e7243d1 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-eefac489\"><div id=\"ez-toc-container\" class=\"ez-toc-v2_0_87_1 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">\u5167\u5bb9\u76ee\u9304<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"\u986f\u793a\/\u96b1\u85cf\u5167\u5bb9\u76ee\u9304\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\" >\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%F0%9F%93%9D%E6%96%87%E5%AD%97%E5%87%BD%E6%95%B8\" >\ud83d\udcdd\u6587\u5b57\u51fd\u6578<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E6%96%87%E5%AD%97%E8%99%95%E7%90%86%E5%9F%BA%E7%A4%8E\" >\u6587\u5b57\u8655\u7406\u57fa\u790e<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E6%96%87%E5%AD%97%E5%AE%9A%E4%BD%8D%E8%88%87%E6%8B%86%E8%A7%A3\" >\u6587\u5b57\u5b9a\u4f4d\u8207\u62c6\u89e3<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E8%B3%87%E6%96%99%E6%B8%85%E6%B4%97\" >\u8cc7\u6599\u6e05\u6d17<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#TEXT_%E5%87%BD%E6%95%B8%EF%BC%88%E6%95%B8%E5%AD%97%E8%BD%89%E6%96%87%E5%AD%97%EF%BC%89\" >TEXT \u51fd\u6578\uff08\u6578\u5b57\u8f49\u6587\u5b57\uff09<\/a><ul class='ez-toc-list-level-4' ><li class='ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E5%9F%BA%E6%9C%AC%E8%AA%9E%E6%B3%95%EF%BC%9ATEXT%E6%95%B8%E5%80%BC_%E2%80%9C%E6%A0%BC%E5%BC%8F%E2%80%9D\" >\u57fa\u672c\u8a9e\u6cd5\uff1aTEXT(\u6578\u503c, &#8220;\u683c\u5f0f&#8221;)<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E5%AF%A6%E5%8B%99%E6%87%89%E7%94%A8\" >\u5be6\u52d9\u61c9\u7528<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E9%80%B2%E9%9A%8E%E6%87%89%E7%94%A8\" >\u9032\u968e\u61c9\u7528<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-4'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E5%B8%B8%E8%A6%8B%E9%8C%AF%E8%AA%A4\" >\u5e38\u898b\u932f\u8aa4<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/yuanstore.tw\/e-learning\/excel-%e6%96%87%e5%ad%97%e5%b8%b8%e7%94%a8%e5%87%bd%e6%95%b8\/#%E8%B3%87%E6%96%99%E5%89%96%E6%9E%90\" >\u8cc7\u6599\u5256\u6790<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n<h2 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%F0%9F%8E%AF_%E5%AD%B8%E7%A8%8B%E7%9B%AE%E6%A8%99\"><\/span>\ud83c\udfaf \u5b78\u7a0b\u76ee\u6a19<span class=\"ez-toc-section-end\"><\/span><\/h2><\/div>\n\n\n\n<ol class=\"wp-block-list has-medium-font-size\">\n<li>\u6587\u5b57\u9577\u5ea6\uff1aLEN<\/li>\n\n\n\n<li>\u53d6\u5b57\uff1aLEFT\u3001MID\u3001RIGHT<\/li>\n\n\n\n<li>\u6578\u503c\u8f49\u6587\u5b57\uff1aTEXT<\/li>\n\n\n\n<li>\u627e\u6587\u5b57\uff1aFIND&#8230;<\/li>\n<\/ol>\n<\/div><\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-2532d548 alignfull uagb-is-root-container\"><div class=\"uagb-container-inner-blocks-wrap\">\n<div class=\"wp-block-uagb-container uagb-block-238cffc8\">\n<div class=\"wp-block-uagb-container uagb-block-6687656e\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-37b326f4\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%F0%9F%93%9D%E6%96%87%E5%AD%97%E5%87%BD%E6%95%B8\"><\/span>\ud83d\udcdd\u6587\u5b57\u51fd\u6578<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/Excel\u6587\u5b57\u51fd\u6578.pdf\" target=\"_blank\" data-type=\"attachment\" data-id=\"1412\" rel=\"noreferrer noopener\">\u53c3\u8003\u8b1b\u7fa9<\/a><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">\u7bc4\u4f8b\uff1a<a href=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/04\/\u6587\u5b57\u51fd\u6578.xlsx\" data-type=\"attachment\" data-id=\"1415\">\u4e0b\u8f09<\/a><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-d2db4a2f\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-cf216876\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%96%87%E5%AD%97%E8%99%95%E7%90%86%E5%9F%BA%E7%A4%8E\"><\/span>\u6587\u5b57\u8655\u7406\u57fa\u790e<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5b78\u7fd2\u76ee\u6a19<\/strong>\uff1a\u719f\u6089\u57fa\u672c\u51fd\u6578\uff0c\u5b78\u6703\u8655\u7406\u683c\u5f0f\u898f\u5f8b\u7684\u8cc7\u6599\u3002<\/li>\n\n\n\n<li><strong>\u6838\u5fc3\u80fd\u529b\u8207\u51fd\u6578<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li><strong>LEN (\u9577\u5ea6)<\/strong>\uff1a\u7406\u89e3\u6587\u5b57\u4e5f\u662f\u6709\u9577\u5ea6\u7684\u6982\u5ff5\u3002<\/li>\n\n\n\n<li><strong>LEFT \/ RIGHT (\u56fa\u5b9a\u5207\u5272)<\/strong>\uff1a\u5b78\u7fd2\u5f9e\u5b57\u4e32\u7684\u524d\u9762\u6216\u5f8c\u9762\u6293\u53d6\u56fa\u5b9a\u6578\u91cf\u7684\u5b57\u5143\u3002<\/li>\n\n\n\n<li><strong>TEXT (\u6578\u5b57\u8f49\u6587\u5b57)<\/strong>\uff1a\u61c9\u7528\u65bc\u5be6\u52d9\u4e0a\u7684\u7de8\u865f\u88dc 0\uff08\u5982\u5c07\u54e1\u5de5\u7de8\u865f 7 \u88dc\u6210 0007\uff09\u6216\u8eab\u5206\u8b49\u683c\u5f0f\u8655\u7406\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u53e3\u8a23\u91d1\u53e5<\/strong>\uff1a<strong>\u300c\u56fa\u5b9a\u9577\u5ea6 \u2192 \u7528 LEFT \/ RIGHT \u89e3\u6c7a\u300d<\/strong>\u3002<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-d8832890\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-482b2c70\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E6%96%87%E5%AD%97%E5%AE%9A%E4%BD%8D%E8%88%87%E6%8B%86%E8%A7%A3\"><\/span>\u6587\u5b57\u5b9a\u4f4d\u8207\u62c6\u89e3<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u5efa\u7acb\u300c\u4f4d\u7f6e\u8a08\u7b97\u601d\u7dad\u300d\uff0c\u5b78\u7fd2\u8655\u7406\u9577\u5ea6\u4e0d\u4e00\u4f46\u6709\u908f\u8f2f\u7684\u8cc7\u6599\u3002<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5b78\u7fd2\u76ee\u6a19<\/strong>\uff1a\u638c\u63e1 Excel \u7684\u5b9a\u4f4d\u908f\u8f2f\uff0c\u5b78\u6703\u7cbe\u6e96\u5207\u5272\u4e2d\u9593\u6587\u5b57\u3002<\/li>\n\n\n\n<li><strong>\u6838\u5fc3\u80fd\u529b\u8207\u51fd\u6578<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li><strong>FIND (\u5b9a\u4f4d)<\/strong>\uff1a\u5b78\u7fd2\u56de\u50b3\u7279\u5b9a\u6587\u5b57\u5728\u5132\u5b58\u683c\u4e2d\u7684\u300c\u6578\u5b57\u4f4d\u7f6e\u300d\u3002<\/li>\n\n\n\n<li><strong>MID (\u5207\u4e2d\u9593)<\/strong>\uff1a\u5728\u5df2\u77e5\u4f4d\u7f6e\u7684\u60c5\u6cc1\u4e0b\u64f7\u53d6\u4e2d\u9593\u5b57\u4e32\u3002<\/li>\n\n\n\n<li><strong>\u9ec3\u91d1\u7d44\u5408\u6280<\/strong>\uff1a\u7d50\u5408 <code>MID<\/code> \u8207 <code>FIND<\/code> \u9032\u884c\u52d5\u614b\u62c6\u89e3\uff08\u4f8b\u5982\uff1a<code>=MID(A2, FIND(\"\u5e02\",A2)+1, FIND(\"\u8def\",A2)-FIND(\"\u5e02\",A2))<\/code>\uff09\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u53e3\u8a23\u91d1\u53e5<\/strong>\uff1a<strong>\u300cExcel \u4e0d\u662f\u5728\u6293\u6587\u5b57\uff0c\u662f\u5728\u6293\u300e\u4f4d\u7f6e\u5dee\u300f\u300d<\/strong>\u3002<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-f3750de3\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-b480cb96\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%B3%87%E6%96%99%E6%B8%85%E6%B4%97\"><\/span>\u8cc7\u6599\u6e05\u6d17<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">\u8655\u7406\u300c\u4e0d\u898f\u5247\u8cc7\u6599\u300d<strong>\u8207<\/strong>\u300c\u4f8b\u5916\u72c0\u6cc1\u300d<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>\u5b78\u7fd2\u76ee\u6a19<\/strong>\uff1a\u5b78\u6703\u8655\u7406\u300c\u4e0d\u4e7e\u6de8\u300d\u7684\u8cc7\u6599\uff0c\u63d0\u5347\u516c\u5f0f\u7684\u9632\u5446\u8207\u5065\u58ef\u6027\u3002<\/li>\n\n\n\n<li><strong>\u6838\u5fc3\u80fd\u529b\u8207\u51fd\u6578<\/strong>\uff1a\n<ul class=\"wp-block-list\">\n<li><strong>FIND + IFERROR (\u9632\u5446\u6a5f\u5236)<\/strong>\uff1a\u8655\u7406\u627e\u4e0d\u5230\u7279\u5b9a\u6587\u5b57\u6642\u7684\u932f\u8aa4\uff08\u5982 <code>IFERROR(FIND(\"\u6bb5\",A2),\"\u6c92\u6709\u6bb5\")<\/code>\uff09\u3002<\/li>\n\n\n\n<li><strong>\u4e0d\u898f\u5247\u5730\u5740\u8655\u7406<\/strong>\uff1a\u91dd\u5c0d\u6709\u7684\u5730\u5740\u6709\u300c\u6bb5\u300d\u3001\u6709\u7684\u6c92\u6709\u300c\u6bb5\u300d\u7684\u60c5\u6cc1\u7de8\u5beb\u5224\u65b7\u516c\u5f0f\u3002<\/li>\n\n\n\n<li><strong>\u5546\u696d\u5834\u666f\u61c9\u7528<\/strong>\uff1a\u5f9e\u6df7\u4e82\u7684\u5546\u54c1\u8cc7\u6599\uff08\u5982\u300cA001-\u7b46\u96fb-\u9ed1\u8272\u300d\uff09\u4e2d\u5206\u5225\u6293\u53d6\u7de8\u865f\u3001\u540d\u7a31\u8207\u984f\u8272\u3002<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong>\u53e3\u8a23\u91d1\u53e5<\/strong>\uff1a<strong>\u300c\u771f\u5be6\u4e16\u754c\u8cc7\u6599\u4e00\u5b9a\u662f\u4e82\u7684\uff0c\u6703\u8655\u7406\u4f8b\u5916\u624d\u662f\u9ad8\u624b\u300d<\/strong>\u3002<\/li>\n<\/ul>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-369c61c6\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-5c2adb78\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"TEXT_%E5%87%BD%E6%95%B8%EF%BC%88%E6%95%B8%E5%AD%97%E8%BD%89%E6%96%87%E5%AD%97%EF%BC%89\"><\/span>TEXT \u51fd\u6578\uff08\u6578\u5b57\u8f49\u6587\u5b57\uff09<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">TEXT \u662f\u628a\u300c\u6578\u503c\u300d\u8f49\u6210\u300c\u6709\u683c\u5f0f\u7684\u6587\u5b57\u300d<\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-77459177\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E5%9F%BA%E6%9C%AC%E8%AA%9E%E6%B3%95%EF%BC%9ATEXT%E6%95%B8%E5%80%BC_%E2%80%9C%E6%A0%BC%E5%BC%8F%E2%80%9D\"><\/span>\u57fa\u672c\u8a9e\u6cd5\uff1aTEXT(\u6578\u503c, &#8220;\u683c\u5f0f&#8221;)<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u88dc 0\uff1a=TEXT(A2,&#8221;0000&#8243;)\uff0c\u56fa\u5b9a\u9577\u5ea6\u7de8\u865f\uff08\u54e1\u5de5\u3001\u8a02\u55ae\uff09<\/li>\n\n\n\n<li>\u91d1\u984d\u683c\u5f0f\uff1a=TEXT(A2,&#8221;#,##0&#8243;)<\/li>\n\n\n\n<li>\u65e5\u671f\u683c\u5f0f\uff1a\n<ul class=\"wp-block-list\">\n<li>=TEXT(A2,&#8221;yyyy\/mm\/dd&#8221;)<\/li>\n\n\n\n<li>=TEXT(A2,&#8221;yyyy\u5e74mm\u6708dd\u65e5&#8221;)<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li> \u661f\u671f\uff1a\n<ul class=\"wp-block-list\">\n<li>=TEXT(A2,&#8221;aaaa&#8221;)\uff0c\u661f\u671f\u516d<\/li>\n\n\n\n<li>=TEXT(A2,&#8221;ddd&#8221;)\uff0c\u516d<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><strong>Excel \u986f\u793a\u683c\u5f0f \u2260 \u6587\u5b57<br>TEXT \u662f\u300c\u771f\u7684\u628a\u683c\u5f0f\u5beb\u9032\u5167\u5bb9\u300d<\/strong><\/p>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-a34b9582\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E5%AF%A6%E5%8B%99%E6%87%89%E7%94%A8\"><\/span>\u5be6\u52d9\u61c9\u7528<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u7d44\u5408\u8a02\u55ae\u7de8\u865f\uff1a=&#8221;ORD-&#8221; &amp; TEXT(A2,&#8221;0000&#8243;)<\/li>\n\n\n\n<li>\u5831\u8868\u65e5\u671f\uff1a=&#8221;\u5831\u8868\u65e5\u671f\uff1a&#8221; &amp; TEXT(TODAY(),&#8221;yyyy\/mm\/dd&#8221;)<\/li>\n\n\n\n<li>\u767c\u7968\u683c\u5f0f\uff1a=TEXT(A2,&#8221;000-000-000&#8243;)<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-89b6be02\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E9%80%B2%E9%9A%8E%E6%87%89%E7%94%A8\"><\/span>\u9032\u968e\u61c9\u7528<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>TEXT + CONCAT\uff1a=&#8221;\u5ba2\u6236\uff1a&#8221; &amp; A2 &amp; &#8221; \/ \u91d1\u984d\uff1a&#8221; &amp; TEXT(B2,&#8221;#,##0&#8243;)<\/li>\n\n\n\n<li>TEXT + IF\uff1a=IF(A2&gt;1000, TEXT(A2,&#8221;#,##0&#8243;) &amp; &#8221; (\u5927\u984d)&#8221;,&#8221;\u4e00\u822c&#8221;)<\/li>\n<\/ul>\n\n\n\n<div class=\"wp-block-uagb-advanced-heading uagb-block-cb954de2\"><h4 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E5%B8%B8%E8%A6%8B%E9%8C%AF%E8%AA%A4\"><\/span>\u5e38\u898b\u932f\u8aa4<span class=\"ez-toc-section-end\"><\/span><\/h4><\/div>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u932f\u8aa4 1\uff1aTEXT \u5f8c\u4e0d\u80fd\u518d\u8a08\u7b97\uff0cTEXT(A2,&#8221;0000&#8243;) + 1   \u274c<\/li>\n\n\n\n<li> \u932f\u8aa4 2\uff1a\u6392\u5e8f\u6703\u932f\uff0c \u6587\u5b57\u6392\u5e8f \u2260 \u6578\u503c\u6392\u5e8f<\/li>\n<\/ul>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\">\n<p class=\"wp-block-paragraph\"><strong>\ud83d\udd39 TEXT = \u683c\u5f0f\u5beb\u9032\u8cc7\u6599<br>\ud83d\udd39 \u986f\u793a\u683c\u5f0f = \u53ea\u662f\u770b\u8d77\u4f86<\/strong><\/p>\n<\/blockquote>\n<\/div>\n\n\n\n<div class=\"wp-block-uagb-container uagb-block-432d829e\">\n<div class=\"wp-block-uagb-advanced-heading uagb-block-fdc4b3f0\"><h3 class=\"uagb-heading-text\"><span class=\"ez-toc-section\" id=\"%E8%B3%87%E6%96%99%E5%89%96%E6%9E%90\"><\/span>\u8cc7\u6599\u5256\u6790<span class=\"ez-toc-section-end\"><\/span><\/h3><\/div>\n\n\n\n<div class=\"wp-block-uagb-image uagb-block-05624121 wp-block-uagb-image--layout-default wp-block-uagb-image--effect-static wp-block-uagb-image--align-none\"><figure class=\"wp-block-uagb-image__figure\"><img decoding=\"async\" src=\"https:\/\/yuanstore.tw\/e-learning\/wp-content\/uploads\/2026\/03\/\u8cc7\u6599\u5256\u6790.png\" alt=\"\u8cc7\u6599\u5256\u6790\" class=\"uag-image-1431\" width=\"493\" height=\"459\" title=\"\u8cc7\u6599\u5256\u6790\" loading=\"lazy\" role=\"img\" \/><\/figure><\/div>\n<\/div>\n<\/div>\n\n\n\n<div class=\"uagb-position__sticky wp-block-uagb-container uagb-block-3c64f7ed\">\n<\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>\u719f\u6089 Excel \u6587\u5b57\u5e38\u7528\u51fd\u6578<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","site-sidebar-layout":"default","site-content-layout":"","ast-site-content-layout":"default","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","ast-disable-related-posts":"","theme-transparent-header-meta":"","adv-header-id-meta":"","stick-header-meta":"","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"default","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-4)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-opacity":"","overlay-gradient":""}},"footnotes":""},"categories":[7],"tags":[],"class_list":["post-1351","post","type-post","status-publish","format-standard","hentry","category-excel"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"kungba","author_link":"https:\/\/yuanstore.tw\/e-learning\/author\/kungba\/"},"uagb_comment_info":0,"uagb_excerpt":"\u719f\u6089 Excel \u6587\u5b57\u5e38\u7528\u51fd\u6578","_links":{"self":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/comments?post=1351"}],"version-history":[{"count":17,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1351\/revisions"}],"predecessor-version":[{"id":1495,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/posts\/1351\/revisions\/1495"}],"wp:attachment":[{"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/media?parent=1351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/categories?post=1351"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/yuanstore.tw\/e-learning\/wp-json\/wp\/v2\/tags?post=1351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}