{"id":125207,"date":"2022-01-10T16:55:12","date_gmt":"2022-01-10T14:55:12","guid":{"rendered":"https:\/\/learnesy.com\/excelfunktioner\/langd\/"},"modified":"2023-07-25T08:30:27","modified_gmt":"2023-07-25T07:30:27","slug":"langd","status":"publish","type":"excel-functions","link":"https:\/\/learnesy.com\/sv\/excelfunktioner\/langd\/","title":{"rendered":"L\u00c4NGD"},"content":{"rendered":"\n<p><em>Se \u00e4ven:<\/em> | <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/vanster-hoger-extext\/\">V\u00c4NSTER, H\u00d6GER &amp; EXTEXT<\/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\/185009887?dnt=1&amp;app_id=122963\" width=\"640\" height=\"360\" frameborder=\"0\" allow=\"autoplay; fullscreen; picture-in-picture; clipboard-write; encrypted-media\"><\/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, <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">Excelfunktioner F\u00f6rdjupning<\/a>!<\/em><\/figcaption><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">Sammanfattning<\/h2>\n\n\n\n<p>L\u00c4NGD-funktionen i Excel returnerar l\u00e4ngden p\u00e5 en given textstr\u00e4ng som antalet tecken. L\u00c4NGD r\u00e4knar \u00e4ven siffror, men inte siffror bel\u00e4gna i en cell som \u00e4r formaterad som <em>tal<\/em>. <\/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-columns is-layout-flex wp-container-core-columns-is-layout-9d6595d7 wp-block-columns-is-layout-flex\">\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Syfte<\/strong><br>Erh\u00e5lla textl\u00e4ngd<br><br><strong>Argument<\/strong><br>text \u2013 <em>Texten f\u00f6r att ber\u00e4kna l\u00e4ngden<\/em><\/p>\n<\/div>\n\n\n\n<div class=\"wp-block-column is-layout-flow wp-block-column-is-layout-flow\">\n<p><strong>Returv\u00e4rde<\/strong><br>Antal tecken av en textstr\u00e4ng<br><br><strong>Syntax<\/strong><br>=L\u00c4NGD(text)<\/p>\n<\/div>\n<\/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 L\u00c4NGD-funktionen i Excel?<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Exempel 1 \u2013 L\u00c4NGD i sin enklaste form<\/h3>\n\n\n\n<p>L\u00c4NGD kan anv\u00e4ndas tillsammans med en cellreferens, eller s\u00e5 kan man skriva textstr\u00e4ngen direkt som nedan. <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=L\u00c4NGD(\"Learnesy l\u00e4r dig Excel\")<\/pre>\n\n\n\n<p>L\u00c4NGD-funktionen i exemplet returnerar talet 22, vilket \u00e4r summan av alla tecken. <em>Detta inkluderar allts\u00e5 mellanslag<\/em>. <\/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 r\u00e4kna antal tecken baserat p\u00e5 ett villkor<\/h3>\n\n\n\n<p>Man kan anv\u00e4nda funktionen L\u00c4NGD f\u00f6r att r\u00e4kna antal tecken baserat p\u00e5 ett villkor. I exemplet nedan anv\u00e4nds L\u00c4NGD i en formel tillsammans med funktionerna <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/summa\/\">SUMMA<\/a> och <a href=\"https:\/\/learnesy.com\/sv\/excelfunktioner\/filter\/\">FILTER<\/a>. Villkoret \u00e4r i det h\u00e4r fallet texten i cell E7. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"783\" height=\"647\" src=\"\/wp-content\/uploads\/2023\/04\/excel-langd-1.png\" alt=\"\" class=\"wp-image-234653\" srcset=\"\/wp-content\/uploads\/2023\/04\/excel-langd-1.png 783w, \/wp-content\/uploads\/2023\/04\/excel-langd-1-300x248.png 300w, \/wp-content\/uploads\/2023\/04\/excel-langd-1-768x635.png 768w\" sizes=\"auto, (max-width: 783px) 100vw, 783px\" \/><figcaption class=\"wp-element-caption\"><em>Exempel 1: h\u00e4r anv\u00e4nds funktionen l\u00e4ngd f\u00f6r att r\u00e4kna antal tecken baserat p\u00e5 ett villkor. <\/em><\/figcaption><\/figure>\n\n\n\n<p>Textstr\u00e4ngarna &#8221;SE619631-7&#8221; och &#8221;NO615000-2&#8221; \u00e4r b\u00e5da av l\u00e4ngden 10 antal tecken, varf\u00f6r resultatet i F7 blir 10+10=20. <\/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 3 \u2013 r\u00e4kna tecken i flera cellomr\u00e5den<\/h3>\n\n\n\n<p>Det g\u00e5r \u00e4ven att r\u00e4kna tecken i flera cellomr\u00e5den. I exemplet nedan anv\u00e4nds funktionen L\u00c4NGD tillsammans med SUMMA och VSTACK. <\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"768\" height=\"672\" src=\"\/wp-content\/uploads\/2023\/04\/excel-langd-2.png\" alt=\"\" class=\"wp-image-234659\" srcset=\"\/wp-content\/uploads\/2023\/04\/excel-langd-2.png 768w, \/wp-content\/uploads\/2023\/04\/excel-langd-2-300x263.png 300w\" sizes=\"auto, (max-width: 768px) 100vw, 768px\" \/><figcaption class=\"wp-element-caption\">Exempel 2: h\u00e4r anv\u00e4nds L\u00c4NGD f\u00f6r att r\u00e4kna ut antal tecken i tv\u00e5 cellintervall. <\/figcaption><\/figure>\n\n\n\n<p>Formeln adderar antal tecken fr\u00e5n cellintervallen B7:B20 och C7:C20, och summeras i cell E7. <\/p>\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 funktionen L\u00c4NGD<\/h2>\n\n\n\n<p>Funktionen L\u00c4NGD returnerar antalet tecken i en given textstr\u00e4ng. L\u00c4NGD tar bara emot ett argument, argumentet <em>text.<\/em> L\u00c4NGD r\u00e4knar antalet tecken i text, inklusive mellanslag och skiljetecken, och returnerar ett tal som resultat. Om text \u00e4r en tom str\u00e4ng (&#8221;&#8221;) eller text \u00e4r en referens till en tom cell, returnerar L\u00c4NGD noll. L\u00c4NGD r\u00e4knar \u00e4ven tecken i str\u00e4ngar eller celler endast inneh\u00e5llande siffror. Till exempel: <\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">=L\u00c4NGD(234)<\/pre>\n\n\n\n<p>resulterar i svaret &#8221;3&#8221;. <\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Bra att veta om L\u00c4NGD-funktionen<\/h3>\n\n\n\n<ul class=\"wp-block-list\">\n<li>L\u00c4NGD returnerar textens l\u00e4ngd som ett tal.<\/li>\n\n\n\n<li>L\u00c4NGD fungerar med siffror, men nummerformatering ing\u00e5r inte.<\/li>\n\n\n\n<li>L\u00c4NGD returnerar noll om ett v\u00e4rde \u00e4r tomt.<\/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 L\u00c4NGD-funktionen i kursen <em><a href=\"https:\/\/learnesy.com\/sv\/courses\/excelfunktioner-fordjupning\/\">Excelfunktioner F\u00f6rdjupning<\/a><\/em> fr\u00e5n vilken lektionen ovan \u00e4r h\u00e4mtad. <\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Har du en fr\u00e5ga eller vill l\u00e4ra dig mer om funktionen? 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-125207","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\/125207","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=125207"}],"wp:term":[{"taxonomy":"excel_function_category","embeddable":true,"href":"https:\/\/learnesy.com\/sv\/wp-json\/wp\/v2\/excel_function_category?post=125207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}