{"id":1568,"date":"2021-11-16T19:31:22","date_gmt":"2021-11-16T11:31:22","guid":{"rendered":"https:\/\/www.fyndpro.com\/?p=1568"},"modified":"2024-09-20T11:31:59","modified_gmt":"2024-09-20T03:31:59","slug":"text-function-7-major-uses","status":"publish","type":"post","link":"https:\/\/www.fyndpro.com\/en\/text-function-7-major-uses\/","title":{"rendered":"TEXT Function: 7 Major Uses"},"content":{"rendered":"

It may seem inconspicuous, but the TEXT function can play a significant role. This time we specifically point out seven major uses of the TEXT function.
\n\u770b\u4f3c\u6beb\u4e0d\u8d77\u773c\uff0c\u537b\u80fd\u8d77\u5230\u5927\u4f5c\u7528\u7684TEXT\u51fd\u6578\uff0c\u5927\u5bb6\u8981\u8a8d\u771f\u5b78\u5b78\u3002\u4eca\u6b21\u7279\u5225\u6307\u51fa\u4e86TEXT\u51fd\u65787\u5927\u529f\u7528\u3002<\/p>\n

The basic syntax is:
\n\u57fa\u672c\u8a9e\u53e5\u662f\uff1a<\/strong><\/p>\n

=TEXT(value to be processed, “format code to be used”)<\/em>
\n=TEXT(\u8981\u8655\u7406\u7684\u6578\u64da,”\u8981\u4f7f\u7528\u7684\u683c\u5f0f\u4ee3\u78bc”)<\/em><\/p>\n

\n
    \n
  1. Add a dollar sign to amounts<\/strong>
    \n\u70ba\u91d1\u984d\u52a0\u4e0a\u7b26\u865f$\uff1a=TEXT(D2,”$0\u5143”)
    \n\"\"<\/p>\n
    \n<\/li>\n
  2. Convert date formats<\/strong>
    \n\u8f49\u63db\u65e5\u671f\u683c\u5f0f\uff1a=TEXT(C2,”e\u5e74mm\u6708dd\u65e5 aaaa”)
    \n\"\"<\/p>\n
    \n<\/li>\n
  3. Simple employee evaluation<\/strong>
    \n\u7c21\u55ae\u7684\u54e1\u5de5\u8003\u8a55\uff1a=TEXT(D2-500,”\u8d85\u984d0\u5143;\u9084\u5dee0\u5143;\u525b\u597d”)
    \n\"\"<\/p>\n
    \n
    \n<\/li>\n
  4. Convert amounts to uppercase<\/strong>
    \n\u91d1\u984d\u8b8a\u6210\u5927\u5beb\uff1a=TEXT(D2,”[DBNum2]0\u5143”)
    \n\"\"<\/p>\n
    \n<\/li>\n
  5. Calculate hours<\/strong>
    \n\u8a08\u7b97\u5c0f\u6642\u6578\uff1a=TEXT(D2-C2,”[h]”)
    \n\"\"<\/p>\n
    \n<\/li>\n
  6. Concatenate text and percentages<\/strong>
    \n\u9023\u63a5\u6587\u5b57\u548c\u767e\u5206\u6bd4\uff1a=”\u5df2\u5b8c\u6210”&TEXT(A2,”0%”)
    \n\"\"<\/p>\n
    \n<\/li>\n
  7. Simplify formula judgments<\/strong>
    \n\u7c21\u5316\u516c\u5f0f\u5224\u65b7\uff1a=TEXT(C2-B2,”\u6bd4\u4e0a\u5e74\u591a0\u5143;\u6bd4\u4e0a\u5e74\u5c110\u5143;\u8207\u4e0a\u5e74\u76f8\u540c”)
    \n\"\"<\/li>\n<\/ol>\n

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

    It may seem inconspicuous, but the TEXT function can pl […]<\/p>\n","protected":false},"author":1,"featured_media":2446,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[8,7,18],"tags":[162],"class_list":["post-1568","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-excel-formulas","category-text","tag-text"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/www.fyndpro.com\/wp-content\/uploads\/2022\/07\/Excel-new1.png?fit=2102%2C679&ssl=1","_links":{"self":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1568","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/comments?post=1568"}],"version-history":[{"count":5,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1568\/revisions"}],"predecessor-version":[{"id":2930,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/posts\/1568\/revisions\/2930"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media\/2446"}],"wp:attachment":[{"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/media?parent=1568"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/categories?post=1568"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.fyndpro.com\/en\/wp-json\/wp\/v2\/tags?post=1568"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}