{"id":6047,"date":"2024-06-21T10:58:38","date_gmt":"2024-06-21T10:58:38","guid":{"rendered":"https:\/\/digitaliserad.nu\/?p=6047"},"modified":"2024-06-21T10:58:38","modified_gmt":"2024-06-21T10:58:38","slug":"fjern-mellemrum-excel-hurtige-tips-og-tricks","status":"publish","type":"post","link":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/","title":{"rendered":"Fjern mellemrum Excel: Hurtige tips og tricks"},"content":{"rendered":"<p>At arbejde med data i Excel kan nogle gange v\u00e6re en udfordring, is\u00e6r n\u00e5r det kommer til at h\u00e5ndtere mellemrum. U\u00f8nskede mellemrum kan skabe problemer i dine dataanalyser og -rapporter. Heldigvis findes der nogle hurtige tips og tricks til at fjern mellemrum i Excel, som kan optimere din datah\u00e5ndtering og -pr\u00e6sentation. L\u00e6r hvordan du effektivt kan rense dine celler for overfl\u00f8dige mellemrum, s\u00e5 din data bliver mere pr\u00e6cis og nemmere at arbejde med.<\/p>\n<h2>Brug Funktionen TRIM<\/h2>\n<p>En af de mest grundl\u00e6ggende m\u00e5der at fjene mellemrum i Excel p\u00e5 er ved brug af TRIM-funktionen. Denne funktion fjerner alle overfl\u00f8dige mellemrum fra tekst, undtagen enkelt mellemrum mellem ord. Her er et hurtigt eksempel p\u00e5, hvordan du anvender den:<\/p>\n<ul>\n<li>Skriv =TRIM(A1) i en tom celle, hvor A1 indeholder teksten med overfl\u00f8dige mellemrum.<\/li>\n<li>Tryk Enter, og du vil se, at teksten nu vises uden ekstra mellemrum.<\/li>\n<li>Tr\u00e6k cellemark\u00f8ren ned for at anvende funktionen p\u00e5 flere celler.<\/li>\n<\/ul>\n<h2>Find og Erstat Funktionen<\/h2>\n<p>En anden praktisk l\u00f8sning for at fjern mellemrum i Excel er &#8216;Find og erstat&#8217;-funktionen. Denne teknik er ideel, hvis du \u00f8nsker at fjerne alle mellemrum, inklusiv dem mellem ord. S\u00e5dan g\u00f8r du:<\/p>\n<ol>\n<li>Tryk p\u00e5 Ctrl + H for at \u00e5bne &#8216;Find og erstat&#8217;-dialogboksen.<\/li>\n<li>Indtast et mellemrum i &#8220;Find hvad&#8221; boksen og lad &#8220;Erstat med&#8221; boksen v\u00e6re tom.<\/li>\n<li>Klik p\u00e5 &#8216;Erstat alle&#8217; for at fjerne alle mellemrum.<\/li>\n<\/ol>\n<h2>Anvend Tekst til Kolonner<\/h2>\n<p>N\u00e5r du har brug for at skille data ad baseret p\u00e5 mellemrum (for eksempel n\u00e5r du har navne i \u00e9n kolonne, som du \u00f8nsker at splitte i for- og efternavn), kan &#8216;Tekst til Kolonner&#8217;-v\u00e6rkt\u00f8jet v\u00e6re yderst nyttigt. F\u00f8lg disse trin:<\/p>\n<ul>\n<li>V\u00e6lg den eller de celler, der indeholder den sammensatte tekst.<\/li>\n<li>G\u00e5 til fanen Data og klik p\u00e5 &#8216;Tekst til Kolonner&#8217;.<\/li>\n<li>V\u00e6lg &#8216;Afbryd&#8217; og klik derefter p\u00e5 &#8216;N\u00e6ste&#8217;.<\/li>\n<li>V\u00e6lg &#8216;Mellemrum&#8217; som skilletegn, sikr dig at andre skilletegn ikke er valgt, og klik p\u00e5 &#8216;N\u00e6ste&#8217;.<\/li>\n<li>Klik p\u00e5 &#8216;Udf\u00f8r&#8217; for at adskille teksten i separate kolonner baseret p\u00e5 mellemrum.<\/li>\n<\/ul>\n<h2>Formler for Avancerede Brugere<\/h2>\n<p>For avancerede Excel-brugere, som \u00f8nsker mere kontrol eller skal h\u00e5ndtere s\u00e6rlige tilf\u00e6lde (som at fjerne ledende, sluttende eller gentagne mellemrum, men ikke enkelte mellemrum mellem ord), kan kombinationer af forskellige funktioner og formler tilbyde en l\u00f8sning. Se nedenst\u00e5ende eksempler:<\/p>\n<table>\n<tr>\n<th>Funktion\/Formel<\/th>\n<th>Beskrivelse<\/th>\n<\/tr>\n<tr>\n<td>=TRIM(SUBSTITUTE(A1, CHAR(160), &#8221; &#8220;))<\/td>\n<td>Fjerner ikke-brydende mellemrum (Char 160) samt overfl\u00f8dige mellemrum.<\/td>\n<\/tr>\n<tr>\n<td>=SUBSTITUTE(TRIM(SUBSTITUTE(A1, &#8221; &#8220;, &#8220;\u263a&#8221;)), &#8220;\u263a&#8221;, &#8221; &#8220;)<\/td>\n<td>Fjerner alle dobbelte mellemrum, mens enkelte mel<\/p>\n","protected":false},"excerpt":{"rendered":"<p>At arbejde med data i Excel kan nogle gange v\u00e6re en udfordring, is\u00e6r n\u00e5r det kommer til at h\u00e5ndtere mellemrum. U\u00f8nskede mellemrum kan skabe problemer i dine dataanalyser og -rapporter. Heldigvis findes der nogle hurtige tips og tricks til at fjern mellemrum i Excel, som kan optimere din datah\u00e5ndtering og -pr\u00e6sentation. L\u00e6r hvordan du effektivt [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":4395,"comment_status":"","ping_status":"","sticky":false,"template":"","format":"standard","meta":{"content-type":"","footnotes":""},"categories":[57],"tags":[],"class_list":{"0":"post-6047","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-blog"},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\" \/>\n<meta property=\"og:locale\" content=\"da_DK\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu\" \/>\n<meta property=\"og:description\" content=\"At arbejde med data i Excel kan nogle gange v\u00e6re en udfordring, is\u00e6r n\u00e5r det kommer til at h\u00e5ndtere mellemrum. U\u00f8nskede mellemrum kan skabe problemer i dine dataanalyser og -rapporter. Heldigvis findes der nogle hurtige tips og tricks til at fjern mellemrum i Excel, som kan optimere din datah\u00e5ndtering og -pr\u00e6sentation. L\u00e6r hvordan du effektivt [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\" \/>\n<meta property=\"og:site_name\" content=\"Digitaliserad.nu\" \/>\n<meta property=\"article:published_time\" content=\"2024-06-21T10:58:38+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Simon Gunnarsson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Skrevet af\" \/>\n\t<meta name=\"twitter:data1\" content=\"Simon Gunnarsson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimeret l\u00e6setid\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutter\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\"},\"author\":{\"name\":\"Simon Gunnarsson\",\"@id\":\"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66\"},\"headline\":\"Fjern mellemrum Excel: Hurtige tips og tricks\",\"datePublished\":\"2024-06-21T10:58:38+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\"},\"wordCount\":438,\"image\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg\",\"articleSection\":[\"Blog\"],\"inLanguage\":\"da-DK\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\",\"url\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\",\"name\":\"Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu\",\"isPartOf\":{\"@id\":\"https:\/\/digitaliserad.nu\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg\",\"datePublished\":\"2024-06-21T10:58:38+00:00\",\"author\":{\"@id\":\"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66\"},\"breadcrumb\":{\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#breadcrumb\"},\"inLanguage\":\"da-DK\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage\",\"url\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg\",\"contentUrl\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg\",\"width\":1000,\"height\":628},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hem\",\"item\":\"https:\/\/digitaliserad.nu\/da\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fjern mellemrum Excel: Hurtige tips og tricks\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/digitaliserad.nu\/#website\",\"url\":\"https:\/\/digitaliserad.nu\/\",\"name\":\"Digitaliserad.nu\",\"description\":\"Tekniknytt\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/digitaliserad.nu\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"da-DK\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66\",\"name\":\"Simon Gunnarsson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"da-DK\",\"@id\":\"https:\/\/digitaliserad.nu\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2022\/01\/successful-young-male-entrepreneur-texting-messaging-with-smartphone-96x96.jpg\",\"contentUrl\":\"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2022\/01\/successful-young-male-entrepreneur-texting-messaging-with-smartphone-96x96.jpg\",\"caption\":\"Simon Gunnarsson\"},\"description\":\"Mitt namn \u00e4r Simon Gunnarsson &amp; jag driver sajten Digitaliserad.nu. Jag \u00e4r en teknikentusiast som \u00e4lskar att skriva om nyheter &amp; utveckling som r\u00f6r teknologi.\",\"sameAs\":[\"https:\/\/digitaliserad.nu\"],\"url\":\"https:\/\/digitaliserad.nu\/da\/author\/digitaliserad\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/","og_locale":"da_DK","og_type":"article","og_title":"Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu","og_description":"At arbejde med data i Excel kan nogle gange v\u00e6re en udfordring, is\u00e6r n\u00e5r det kommer til at h\u00e5ndtere mellemrum. U\u00f8nskede mellemrum kan skabe problemer i dine dataanalyser og -rapporter. Heldigvis findes der nogle hurtige tips og tricks til at fjern mellemrum i Excel, som kan optimere din datah\u00e5ndtering og -pr\u00e6sentation. L\u00e6r hvordan du effektivt [&hellip;]","og_url":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/","og_site_name":"Digitaliserad.nu","article_published_time":"2024-06-21T10:58:38+00:00","og_image":[{"width":1000,"height":628,"url":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg","type":"image\/jpeg"}],"author":"Simon Gunnarsson","twitter_card":"summary_large_image","twitter_misc":{"Skrevet af":"Simon Gunnarsson","Estimeret l\u00e6setid":"2 minutter"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#article","isPartOf":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/"},"author":{"name":"Simon Gunnarsson","@id":"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66"},"headline":"Fjern mellemrum Excel: Hurtige tips og tricks","datePublished":"2024-06-21T10:58:38+00:00","mainEntityOfPage":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/"},"wordCount":438,"image":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage"},"thumbnailUrl":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg","articleSection":["Blog"],"inLanguage":"da-DK"},{"@type":"WebPage","@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/","url":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/","name":"Fjern mellemrum Excel: Hurtige tips og tricks - Digitaliserad.nu","isPartOf":{"@id":"https:\/\/digitaliserad.nu\/#website"},"primaryImageOfPage":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage"},"image":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage"},"thumbnailUrl":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg","datePublished":"2024-06-21T10:58:38+00:00","author":{"@id":"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66"},"breadcrumb":{"@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#breadcrumb"},"inLanguage":"da-DK","potentialAction":[{"@type":"ReadAction","target":["https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/"]}]},{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#primaryimage","url":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg","contentUrl":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2024\/05\/2151252419.jpg","width":1000,"height":628},{"@type":"BreadcrumbList","@id":"https:\/\/digitaliserad.nu\/da\/blog\/fjern-mellemrum-excel-hurtige-tips-og-tricks\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hem","item":"https:\/\/digitaliserad.nu\/da\/"},{"@type":"ListItem","position":2,"name":"Fjern mellemrum Excel: Hurtige tips og tricks"}]},{"@type":"WebSite","@id":"https:\/\/digitaliserad.nu\/#website","url":"https:\/\/digitaliserad.nu\/","name":"Digitaliserad.nu","description":"Tekniknytt","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/digitaliserad.nu\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"da-DK"},{"@type":"Person","@id":"https:\/\/digitaliserad.nu\/#\/schema\/person\/3fd225e4aed5ef97e640e8735c030d66","name":"Simon Gunnarsson","image":{"@type":"ImageObject","inLanguage":"da-DK","@id":"https:\/\/digitaliserad.nu\/#\/schema\/person\/image\/","url":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2022\/01\/successful-young-male-entrepreneur-texting-messaging-with-smartphone-96x96.jpg","contentUrl":"https:\/\/digitaliserad.nu\/wp-content\/uploads\/2022\/01\/successful-young-male-entrepreneur-texting-messaging-with-smartphone-96x96.jpg","caption":"Simon Gunnarsson"},"description":"Mitt namn \u00e4r Simon Gunnarsson &amp; jag driver sajten Digitaliserad.nu. Jag \u00e4r en teknikentusiast som \u00e4lskar att skriva om nyheter &amp; utveckling som r\u00f6r teknologi.","sameAs":["https:\/\/digitaliserad.nu"],"url":"https:\/\/digitaliserad.nu\/da\/author\/digitaliserad\/"}]}},"_links":{"self":[{"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/posts\/6047","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/comments?post=6047"}],"version-history":[{"count":1,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/posts\/6047\/revisions"}],"predecessor-version":[{"id":6756,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/posts\/6047\/revisions\/6756"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/media\/4395"}],"wp:attachment":[{"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/media?parent=6047"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/categories?post=6047"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/digitaliserad.nu\/da\/wp-json\/wp\/v2\/tags?post=6047"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}