{"id":890,"date":"2019-04-22T15:18:19","date_gmt":"2019-04-22T12:18:19","guid":{"rendered":"https:\/\/www.test4u.eu\/excelpedia\/?p=890"},"modified":"2019-04-22T15:18:23","modified_gmt":"2019-04-22T12:18:23","slug":"the-trim-function","status":"publish","type":"post","link":"https:\/\/www.test4u.eu\/excelpedia\/the-trim-function\/","title":{"rendered":"The TRIM Function"},"content":{"rendered":"\n<p>Removes all the spaces from the text except the single spaces between words. <\/p>\n\n\n\n<p>The syntax of the function is the following: <\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-style-large is-layout-flow wp-block-quote-is-layout-flow\"><p> <strong>TRIM<\/strong><em>(<span><b>text<\/b><\/span><\/em>) <\/p><cite><font color=\"#191e23\"><span><b>text<\/b><\/span><\/font>: The text from which you want to remove the spaces.<br><\/cite><\/blockquote>\n\n\n\n<div style=\"height:20px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Click on the button to practice using this function, with the help of our <strong>Online Assessment Tool<\/strong>:<\/p>\n\n\n<p class=\"button-practice-container\" ><a class=\"button button-primary button-practice\" style=\"height:auto\"  href=\"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/plugins\/unlimited-integration\/run.php?id=emdtaDh1UFdwZmJyNkd1dFZXRCsxbkZOMThuaVR5MDVjSjA4Y0lSQ21KWVpBUmN2R3VSbGpjK1lHclhGMkdQcw==&b=NnRIYjVUbnJBRzhIWEVBa3lVdEpoeGxLQ245ZzdzU0N1RFNwdVh2YlFoVHIzaHVEdlVudGs0N2pwY2REL1FUSi8yRHlQcVFtZGN3Zld3QTRSOGNZcTdLRFFicWNvekFqZHU4ZmdPWEpxNm89\">Practice<\/a><\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n\n<p class=\"has-medium-font-size\"><strong>Here is an example of how to use the TRIM function:<\/strong><\/p>\n\n\n\n<p>Enter in the cell B2 the appropriate function which will return the text appearing in the cell A2 deleting spaces before and after the name. Copy the function in the cell range \u03923:\u03924.<\/p>\n\n\n\n<figure class=\"wp-block-embed-youtube wp-block-embed is-type-video is-provider-youtube wp-embed-aspect-4-3 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/GOZeq-rIizc?version=3&#038;rel=0&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Removes all the spaces from the text except the single spaces between words. <\/p>\n","protected":false},"author":2,"featured_media":891,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[4],"tags":[94,112],"class_list":["post-890","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-functions","tag-text-functions","tag-trim"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/www.test4u.eu\/excelpedia\/wp-content\/uploads\/2019\/04\/trim.jpg","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/paRnIz-em","_links":{"self":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/890","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/comments?post=890"}],"version-history":[{"count":0,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/posts\/890\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media\/891"}],"wp:attachment":[{"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/media?parent=890"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/categories?post=890"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.test4u.eu\/excelpedia\/wp-json\/wp\/v2\/tags?post=890"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}