{"id":125203,"date":"2022-01-10T16:59:10","date_gmt":"2022-01-10T14:59:10","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/rensa-stada\/"},"modified":"2023-09-01T12:27:43","modified_gmt":"2023-09-01T11:27:43","slug":"rensa-stada","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/rensa-stada\/","title":{"rendered":"RENSA &#038; ST\u00c4DA"},"content":{"rendered":"\n<p>| <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/byt-ut-ersatt\/\" data-type=\"excel-functions\" data-id=\"125179\">BYT.UT, ERS\u00c4TT<\/a> |<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-vimeo wp-block-embed-vimeo wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/185009889?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<\/div><figcaption class=\"wp-element-caption\"><em>Den h\u00e4r lektionen och m\u00e5nga andra finner man i Learnesys f\u00f6rdjupningskurs i Excel,&nbsp;<a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>Excel-funktionen RENSA tar bort extra mellanslag fr\u00e5n text, vilket l\u00e4mnar endast ett enstaka blanksteg mellan ord och inga blanksteg i b\u00f6rjan eller slutet av texten.<\/p>\n\n\n\n<p>Excel-funktionen ST\u00c4DA tar en textstr\u00e4ng och returnerar text som har blivit &#8221;st\u00e4dad&#8221; fr\u00e5n radbrytningar och andra icke-utskriftsbara tecken.<\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<div class=\"wp-block-group\"><div class=\"wp-block-group__inner-container is-layout-constrained wp-block-group-is-layout-constrained\">\n<p><strong>Syfte<\/strong><br><\/p>\n\n\n\n<p>RENSA \u2013 Ta bort extra mellanslag fr\u00e5n texten.<br>ST\u00c4DA \u2013 Ta bort icke-utskriftsbara tecken fr\u00e5n texten.<\/p>\n\n\n\n<p><br><strong>Argument<\/strong><br>RENSA<br>     <em>text<\/em> \u2013 Den text fr\u00e5n vilken man \u00f6nskar att ta bort extra mellanslag.<br>ST\u00c4DA<br>     <em>text<\/em> \u2013 Den text man \u00f6nskar att st\u00e4da fr\u00e5n icke-utskriftsbara tecken.<br><br><strong>Returv\u00e4rde<\/strong><br>RENSA \u2013 en textstr\u00e4ng utan o\u00f6nskade blanksteg.<br>ST\u00c4DA \u2013 en textstr\u00e4ng utan icke-utskriftsbara tecken.<br><br><strong>Syntax<\/strong><br>RENSA(<em>text<\/em>)<br>ST\u00c4DA(<em>text<\/em>)<\/p>\n<\/div><\/div>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Hur anv\u00e4nder man funktionera RENSA och ST\u00c4DA i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 RENSA och ST\u00c4DA i sitt simplaste utf\u00f6rande<\/h3>\n\n\n\n<p>De b\u00e5da funktionerna tar emot en cellreferens eller en textstr\u00e4ng som argument:<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">=RENSA(TECKENKOD(12)&amp;\" Learnesy \u00e4r plattformen f\u00f6r Excel och dataanalys!\"&amp;\" \"&amp;TECKENKOD(14))\n\/\/\/ Resultatet blir: \"\fLearnesy \u00e4r plattformen f\u00f6r Excel och dataanalys! \u000e\"\n\n=ST\u00c4DA(TECKENKOD(12)&amp;\" Learnesy \u00e4r plattformen f\u00f6r Excel och dataanalys!\"&amp;\" \"&amp;TECKENKOD(14))\n\/\/\/ Resultatet blir: \" Learnesy    \u00e4r plattformen f\u00f6r Excel och    dataanalys! \"<\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Som man kan se inneh\u00e5ller b\u00e5da resultaten o\u00f6nskade tecken. D\u00e4rf\u00f6r kan man anv\u00e4nda dem b\u00e5da tillsammans. <\/p>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 2 \u2013 RENSA och ST\u00c4DA tillsammans<\/h3>\n\n\n\n<p>Anv\u00e4nds funktionerna RENSA och ST\u00c4DA tillsammans i en formel, kommer detta l\u00f6sa problemet fr\u00e5n Exempel 1:<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">RENSA(ST\u00c4DA(TECKENKOD(12)&amp;\" Learnesy \u00e4r plattformen f\u00f6r Excel och dataanalys!\"&amp;\" \"&amp;TECKENKOD(14)))<\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>Resultatet av detta blir &#8221;<em>Learnesy \u00e4r plattformen f\u00f6r Excel och dataanalys!<\/em>&#8221;. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 3 \u2013 alternativ till funktionen ST\u00c4DA<\/h3>\n\n\n\n<p>Funktionen ST\u00c4DA tar bort de f\u00f6rsta 32 (ej utskrivbara) tecknena i den 7-bitars ASCII-koden (v\u00e4rden 0 till 31) fr\u00e5n text. F\u00f6r att ta bort specifika tecken ut\u00f6ver de f\u00f6rsta 32 ASCII-tecknen kan du anv\u00e4nda <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/byt-ut-ersatt\/\" data-type=\"excel-functions\" data-id=\"125179\">BYT.UT<\/a>-funktionen med <em>TECKENKOD<\/em>-funktionen. Till exempel f\u00f6r att ta bort tecken nr 206:<\/p>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<pre class=\"wp-block-preformatted\">=BYT.UT(A1;TECKENKOD(204);\"\")<\/pre>\n\n\n\n<div style=\"height:25px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<p>d\u00e4r A1 representerar cellen inneh\u00e5llande texten vi vill manipulera. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"748\" height=\"468\" src=\"\/wp-content\/uploads\/2023\/09\/excel-rensa-stada-1.png\" alt=\"\" class=\"wp-image-255490\" srcset=\"\/wp-content\/uploads\/2023\/09\/excel-rensa-stada-1.png 748w, \/wp-content\/uploads\/2023\/09\/excel-rensa-stada-1-300x188.png 300w\" sizes=\"auto, (max-width: 748px) 100vw, 748px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 3: h\u00e4r anv\u00e4nds funktionen BYT.UT ist\u00e4llet f\u00f6r funktionen ST\u00c4DA f\u00f6r att ta bort teckenkod nr 200.<\/em><\/figcaption><\/figure>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<div style=\"height:50px\" aria-hidden=\"true\" class=\"wp-block-spacer\"><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Mer om funktionerna RENSA och ST\u00c4DA i Excel<\/h2>\n\n\n\n<p>Funktionen ST\u00c4DA accepterar en textstr\u00e4ng och returnerar text som har &#8221;rensats&#8221; fr\u00e5n radbrytningar och andra icke-utskrivbara tecken. Du kan anv\u00e4nda ST\u00c4DA f\u00f6r att ta bort tecken som inte skrivs ut och radbrytningar fr\u00e5n text. <br>Funktionen ST\u00c4DA accepterar endast ett argument, text, som kan vara en textstr\u00e4ng eller ett nummer. ST\u00c4DA tar bort de f\u00f6rsta 32 icke-utskrivbara tecknen i 7-bitars ASCII-koden (v\u00e4rden 0 till 31), om s\u00e5dana finns, och returnerar resultatet. Text utan dessa tecken returneras of\u00f6r\u00e4ndrad. Observera att ST\u00c4DA kommer att ta bort radbrytningar om de finns.<br>ST\u00c4DA kommer inte att ta bort extra blanksteg. F\u00f6r att ta bort extra blanksteg, anv\u00e4nd RENSA-funktionen, vars enda syftet \u00e4r just att ta bort \u00f6verfl\u00f6diga blanksteg.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om RENSA och ST\u00c4DA-funktionerna<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>RENSA tar bort extra blanksteg fr\u00e5n texten och l\u00e4mnar endast ett blanksteg mellan ord, samt inga blanksteg i b\u00f6rjan eller slutet av texten. <\/li>\n\n\n\n<li>RENSA \u00e4r anv\u00e4ndbart n\u00e4r man rensar upp text som kommer fr\u00e5n andra applikationer eller milj\u00f6er.<\/li>\n\n\n\n<li>RENSA tar endast bort ASCII-mellanslagstecknet (32) fr\u00e5n texten. <\/li>\n\n\n\n<li>Funktionen ST\u00c4DA tar bort de f\u00f6rsta 32 (ej utskrivbara) tecknena i den 7-bitars ASCII-koden.<\/li>\n\n\n\n<li>F\u00f6r \u00f6vriga ej utskrivbara-tecken, anv\u00e4nd ers\u00e4tt ST\u00c4DA med BYT.UT-funktionen.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Mer l\u00e4sning<\/h3>\n\n\n\n<p>Man l\u00e4r sig mer om RENSA och ST\u00c4DA i v\u00e5r kurs <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em>!<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionerna? Bes\u00f6k d\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/sv\/forums\/excel\/\">forum<\/a> eller v\u00e5r <a href=\"https:\/\/learnesy.com\/sv\/resursbank\/\">resursbank<\/a>.<\/li>\n\n\n\n<li>Vill du har fler Exceltips? P\u00e5 Learnesys <a href=\"https:\/\/learnesy.com\/sv\/blogg\/\">blogg<\/a> hittar du massvis av tips! Eller, prenumerera p\u00e5 v\u00e5rt <a href=\"https:\/\/learnesy.com\/newsletter\/\">nyhetsbrev<\/a>. <\/li>\n\n\n\n<li><a href=\"https:\/\/learnesy.com\/sv\/courses\/\">Till v\u00e5ra kurssidor \u2192<\/a><\/li>\n<\/ul>\n","protected":false},"featured_media":0,"menu_order":0,"template":"","excel_function_category":[309],"class_list":["post-125203","excel-functions","type-excel-functions","status-publish","hentry","excel_function_category-textfunktioner-sv"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions\/125203","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel-functions"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/excel-functions"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=125203"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125203"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}