{"id":494818,"date":"2025-10-28T12:17:37","date_gmt":"2025-10-28T11:17:37","guid":{"rendered":"https:\/\/learnesy.com\/?p=494818"},"modified":"2025-10-28T12:44:23","modified_gmt":"2025-10-28T11:44:23","slug":"veckans-exceltips-regex-funktionerna","status":"publish","type":"post","link":"https:\/\/learnesy.com\/sv\/veckans-exceltips-regex-funktionerna\/","title":{"rendered":"Veckans Exceltips: REGEX-funktionerna"},"content":{"rendered":"<p data-start=\"65\" data-end=\"111\"><em>Att hantera text i Excel har blivit betydligt enklare med de nya REGEX-funktionerna. Oavsett om du vill rensa data, hitta specifika m\u00f6nster eller strukturera text p\u00e5 ett smartare s\u00e4tt ger REGEX dig verktygen att g\u00f6ra det. Svaren p\u00e5 varf\u00f6r och hur finner du i lektionen nedan.<\/em><\/p>\n<div class=\"embed-container\"><iframe loading=\"lazy\" src=\"https:\/\/player.vimeo.com\/video\/1120109644?dnt=1&amp;app_id=122963\" width=\"640\" height=\"400\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\"><\/iframe><\/div>\n<hr \/>\n<span id=\"heading-upptack-kraften-i-excel-funktionen-regex\"><h3 data-start=\"65\" data-end=\"111\">Uppt\u00e4ck kraften i Excel-funktionen REGEX<\/h3><\/span>\n<p data-start=\"113\" data-end=\"362\">Visste du att du kan anv\u00e4nda <strong data-start=\"142\" data-end=\"151\">REGEX<\/strong> i Excel f\u00f6r att arbeta med avancerade textm\u00f6nster? Med REGEX-funktionerna kan du s\u00f6ka, extrahera och ers\u00e4tta text baserat p\u00e5 s\u00e5 kallade <em data-start=\"288\" data-end=\"307\">regulj\u00e4ra uttryck<\/em> som \u00e4r ett kraftfullt s\u00e4tt att k\u00e4nna igen m\u00f6nster i text.<\/p>\n<p data-start=\"364\" data-end=\"390\">Det finns tre varianter:<\/p>\n<p data-start=\"393\" data-end=\"460\"><strong data-start=\"393\" data-end=\"406\">-REGEXTEST<\/strong> \u2013 kontrollerar om texten matchar ett visst m\u00f6nster.<br \/>\n<strong data-start=\"463\" data-end=\"478\">-REGEXUTDRAG<\/strong> \u2013 h\u00e4mtar text som matchar m\u00f6nstret.<br \/>\n<strong data-start=\"519\" data-end=\"534\">-REGEXERS\u00c4TT<\/strong> \u2013 ers\u00e4tter text som matchar m\u00f6nstret med n\u00e5got annat.<\/p>\n<p data-start=\"592\" data-end=\"705\">Med REGEX kan du snabbt rensa data, hitta r\u00e4tt information eller strukturera text p\u00e5 nya s\u00e4tt, direkt i Excel. Det \u00e4r en av flera nya lektioner i v\u00e5r kurs <a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\"><em><strong>Excelfunktioner i praktiken<\/strong><\/em><\/a>. Just nu kan du prova kursen gratis i 7 dagar, eller ta del av v\u00e5rt erbjudande. Anv\u00e4nd kod <strong>LG64KNI\u00a0<\/strong>f\u00f6r 20% rabatt p\u00e5 kursen.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Uppt\u00e4ck kraften och nyttan med Excels REGEX-funktioner!<\/p>\n","protected":false},"author":54291,"featured_media":494824,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_eb_attr":"","footnotes":""},"categories":[160],"tags":[],"class_list":["post-494818","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-tips"],"acf":[],"_links":{"self":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/494818","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/users\/54291"}],"replies":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/comments?post=494818"}],"version-history":[{"count":3,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/494818\/revisions"}],"predecessor-version":[{"id":494837,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/posts\/494818\/revisions\/494837"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media\/494824"}],"wp:attachment":[{"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/media?parent=494818"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/categories?post=494818"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/tags?post=494818"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}