{"id":58293,"date":"2023-09-11T22:54:50","date_gmt":"2023-09-11T14:54:50","guid":{"rendered":"https:\/\/www.juejinka.com\/?p=58293"},"modified":"2023-09-11T22:54:53","modified_gmt":"2023-09-11T14:54:53","slug":"excel-%e6%95%99%e5%ad%a6-%e5%85%a8%e5%bd%a2%e6%96%87%e5%ad%97%e5%8f%98%e5%8d%8a%e5%bd%a2%ef%bc%8c%e5%a6%82%e6%9e%9c%e8%8b%b1%e6%95%b0%e6%b7%b7%e5%90%88%e5%8f%88%e8%af%a5%e6%80%8e%e4%b9%88","status":"publish","type":"post","link":"https:\/\/www.juejinka.com\/y\/58293.html","title":{"rendered":"Excel \u6559\u5b66 \u2013 \u5168\u5f62\u6587\u5b57\u53d8\u534a\u5f62\uff0c\u5982\u679c\u82f1\u6570\u6df7\u5408\u53c8\u8be5\u600e\u4e48\u5206\u5f00\u53d8\uff1f"},"content":{"rendered":"\n

\u4eca\u5929\u88ab\u7f51\u53cb\u5dee\u70b9\u95ee\u5012\uff0c\u6709\u4eba\u95ee\u4e86\u6211\u8981\u600e\u4e48\u5c06\u5168\u5f62\u6587\u5b57\u90fd\u53d8\u6210\u534a\u5f62\uff0c\u8fd9\u4e2a\u5012\u662f\u7b80\u5355\uff0c\u6709\u51fd\u6570\u5c31\u80fd\u7b80\u5355\u8fbe\u6210\uff0c\u4f46\u540e\u9762\u8ffd\u95ee\u4e86\u6211\uff0c\u90a3\u5982\u679c\u4ed6\u662f\u82f1\u6570\u6df7\u5408\u5185\u5bb9\uff0c\u4f46\u53ea\u6709\u6570\u5b57\u8981\u53d8\u6210\u534a\u5f62\u600e\u4e48\u529e\uff1f \u6211\u601d\u7ef4\u4e86\u534a\u5929\u5728\u60f3\u600e\u4e48\u505a\uff0c\u6700\u540e\u597d\u4e0d\u5bb9\u6613\u89e3\u4e86\u51fa\u6765\uff0c\u8fd9\u8fd8\u771f\u7684\u6ca1\u6709\u6bd4\u8f83\u7b80\u5355\u7684\u505a\u6cd5\uff0c\u5230\u5e95\u8981\u600e\u4e48\u505a\u5462\uff1f \u5f80\u4e0b\u5c31\u6765\u5206\u4eab\u4eca\u5929\u7684 Excel \u6559\u5b66\u5427\uff0c\u771f\u7684\u86ee\u96be\u7684…<\/p>\n\n\n\n

Excel \u6559\u5b66 – \u5168\u5f62\u6587\u5b57\u53d8\u534a\u5f62<\/h2>\n\n\n\n

\u6765\uff0c\u8bf4\u660e\u4e00\u4e0b\uff0c\u6700\u57fa\u672c\u7684\u8bfe\u9898\u50cf\u8fd9\u6837\uff0c\u5168\u5f62\u6587\u5b57\uff0c\u8981\u600e\u4e48\u8f6c\u6210\u534a\u5f62\uff0c\u6211\u4eec\u5f80\u4e0b\u6765\u770b\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u8981\u8f6c\u6210\u534a\u5f62\u975e\u5e38\u4e4b\u7b80\u5355\uff0c\u53ea\u8981\u5229\u7528 ASC \u8fd9\u4e2a\u51fd\u6570\uff0c\u6bd4\u5982\u50cf\u662f A2 \u7684\u6587\u5b57\uff0c\u516c\u5f0f\u5982\u4e0b\uff1a<\/p>\n\n\n\n

\n

=ASC(A2)<\/p>\n<\/blockquote>\n\n\n\n

\u8fd9\u6837\u5c31\u641e\u5b9a\u4e86\uff0c\u662f\u4e0d\u662f\u5f88\u7b80\u5355\uff0c\u4e0d\u8fc7\u771f\u6b63\u96be\u7684\u6765\u4e86\uff0c\u518d\u5f80\u4e0b\u6765\u770b\u770b\u6211\u5dee\u70b9\u88ab\u95ee\u5012\u7684\u3002<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

\u8981\u600e\u4e48\u628a\u82f1\u6570\u6df7\u5408\u5185\u5bb9\u53d8\u6210\u534a\u5f62\uff1f \u8fd9\u6211\u771f\u7684\u60f3\u4e86\u5f88\u4e45\u8981\u600e\u4e48\u505a\uff0c\u6700\u540e\u5f04\u4e86\u4e00\u4e2a\u6bd4\u8f83\u571f\u6cd5\u7ec3\u94a2\u7684\u516c\u5f0f\u4e32\uff0c\u5982\u4e0b\uff1a<\/p>\n\n\n\n

\n

=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A2,”\uff10”,”0″),”\uff11”,”1″),”\uff12”,”2″),”\uff13”,”3″),”\uff14”,”4″),”\uff15”,”5″ ),”\uff16”,”6″),”\uff17”,”7″),”\uff18”,”8″),”\uff19”,”9″)<\/p>\n<\/blockquote>\n\n\n\n

\u6211\u539f\u672c\u662f\u60f3\u8981\u601d\u7ef4\u7740\uff0c\u5c06\u6587\u5b57\u5168\u62c6\u5f00\u540e\uff0c\u518d\u5404\u5b57\u8f6c\u6210\u534a\u5f62\u518d\u5408\u5e76\uff0c\u4f46\u8fd9\u6837\u597d\u50cf\u6709\u70b9\u9ebb\u70e6\uff0c\u8fd8\u8981\u5217\u9635\u8fd8\u8981\u597d\u51e0\u5c42\u53e0\u4e00\u53e0\uff0c\u540e\u6765\u6211\u89c9\u5f97\u5355\u7eaf\u7528SUBSTITUTE\u8fd9\u4e2a\u51fd\u6570\u6765\u505a\uff0c\u8fd9\u51fd\u6570\u7684\u516c\u7528\u662f\u53d6\u4ee3\u6587\u5b57\u4e32\u91cc\u7684\u5185\u5bb9\uff0c\u867d\u7136\u516c\u5f0f\u770b\u8d77\u6765\u5f88\u957f\uff0c\u4e0d\u8fc7\u8fd9\u91cd\u70b9\u5c31\u662f\u6bcf\u4e2a\u5b57\u7b26\u4e32\u505a\u5341\u6b21\uff0c\u4ece0\u53d6\u4ee3\u52309\uff0c\u7a0d\u5fae\u571f\u6cd5\u94fe\u94a2\u4e00\u70b9\uff0c\u4f46\u7ed3\u8bba\u6765\u8bf4\u662f\u5b8c\u7f8e\u7684\u3002<\/p>\n\n\n\n

\u4f46\u5982\u679c\u4f60\u662f\u60f3\u8981\u5355\u7eaf\u53d6\u4ee3\u6389\u82f1\u6587\u53d8\u6210\u534a\u5f62\uff0c\u90a3\u6211\u5c31\u644a\u624b\u4e86\uff0c\u5982\u679c\u7528\u4e0a\u9762\u8fd9\u65b9\u5f0f\uff0c\u4e0d\u662f\u4e0d\u884c\uff0c\u53ea\u662f\u5c31\u662f 26 \u4e2a\u5b57\u6bcd\u5927\u5c0f\u5199\u52a0\u8d77\u6765\u4f60\u603b\u5171\u8981\u5199 52 \u5c42\u7684\u516c\u5f0f\uff0c\u5e94\u8be5\u4f1a\u6b7b\u6389\u554a….<\/p>\n\n\n\n

\"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"

\u4eca\u5929\u88ab\u7f51\u53cb\u5dee\u70b9\u95ee\u5012\uff0c\u6709\u4eba\u95ee\u4e86\u6211\u8981\u600e\u4e48\u5c06\u5168\u5f62\u6587\u5b57\u90fd\u53d8\u6210\u534a\u5f62\uff0c\u8fd9\u4e2a\u5012\u662f\u7b80\u5355\uff0c\u6709\u51fd\u6570\u5c31\u80fd\u7b80\u5355\u8fbe\u6210\uff0c\u4f46\u540e\u9762\u8ffd\u95ee\u4e86\u6211\uff0c\u90a3\u5982\u679c\u4ed6\u662f\u82f1\u6570\u6df7\u5408\u5185\u5bb9\uff0c\u4f46\u53ea\u6709\u6570\u5b57\u8981\u53d8\u6210\u534a\u5f62\u600e\u4e48\u529e\uff1f \u6211\u601d\u7ef4\u4e86\u534a\u5929\u5728\u60f3\u600e…<\/p>\n","protected":false},"author":4,"featured_media":58294,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"special":[],"_links":{"self":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/58293"}],"collection":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/comments?post=58293"}],"version-history":[{"count":1,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/58293\/revisions"}],"predecessor-version":[{"id":58297,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/posts\/58293\/revisions\/58297"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/media\/58294"}],"wp:attachment":[{"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/media?parent=58293"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/categories?post=58293"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/tags?post=58293"},{"taxonomy":"special","embeddable":true,"href":"https:\/\/www.juejinka.com\/news\/wp-json\/wp\/v2\/special?post=58293"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}