{"id":8386,"date":"2017-06-28T21:45:56","date_gmt":"2017-06-28T19:45:56","guid":{"rendered":"http:\/\/blog.wenzlaff.de\/?p=8386"},"modified":"2018-09-07T16:25:39","modified_gmt":"2018-09-07T14:25:39","slug":"mac-os-x-excel-15-35-das-neue-trim-heisst-glaetten-oder-wie-loesche-ich-leerzeichen-in-text","status":"publish","type":"post","link":"http:\/\/blog.wenzlaff.de\/?p=8386","title":{"rendered":"Mac OS X Excel 15.35:  Das neue Trim hei\u00dft Gl\u00e4tten oder wie l\u00f6sche ich Leerzeichen in Text"},"content":{"rendered":"<p>Wer Leerzeichen in Excel vorne, hinten oder im Text l\u00f6schen will, hat das fr\u00fcher mit <strong>trim<\/strong> gemacht. Jetzt hei\u00dft die Funktion &#8222;Gl\u00e4tten&#8220; \ud83d\ude41 Darauf soll man nur kommen! Wer l\u00e4\u00dft sich denn sowas einfallen?<\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.43.51.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.43.51.png\" alt=\"\" width=\"295\" height=\"628\" class=\"aligncenter size-full wp-image-8390\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.43.51.png 295w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.43.51-141x300.png 141w\" sizes=\"auto, (max-width: 295px) 100vw, 295px\" \/><\/a><\/p>\n<p>Und hier mal ein Beispiel:<!--more--><\/p>\n<p><a href=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.37.57.png\"><img loading=\"lazy\" decoding=\"async\" src=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.37.57.png\" alt=\"\" width=\"813\" height=\"264\" class=\"aligncenter size-full wp-image-8387\" srcset=\"http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.37.57.png 813w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.37.57-300x97.png 300w, http:\/\/blog.wenzlaff.de\/wp-content\/uploads\/2017\/06\/Bildschirmfoto-2017-06-28-um-21.37.57-768x249.png 768w\" sizes=\"auto, (max-width: 767px) 89vw, (max-width: 1000px) 54vw, (max-width: 1071px) 543px, 580px\" \/><\/a><\/p>\n<p>Mein Vorschlag &#8222;Bereinigen&#8220; \ud83d\ude09 und Deiner?<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Wer Leerzeichen in Excel vorne, hinten oder im Text l\u00f6schen will, hat das fr\u00fcher mit trim gemacht. Jetzt hei\u00dft die Funktion &#8222;Gl\u00e4tten&#8220; \ud83d\ude41 Darauf soll man nur kommen! Wer l\u00e4\u00dft sich denn sowas einfallen? Und hier mal ein Beispiel:<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[2310,2880,2882,2248,581,2883,2881],"class_list":["post-8386","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-excel","tag-glaetten","tag-im-text","tag-leerzeichen","tag-statistik","tag-text-bereinigen","tag-trim"],"_links":{"self":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/8386","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=8386"}],"version-history":[{"count":0,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=\/wp\/v2\/posts\/8386\/revisions"}],"wp:attachment":[{"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=8386"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=8386"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/blog.wenzlaff.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=8386"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}