---
title: "Opgaver med REGEX-funktioner i Google Sheets | ExcelOpgaver"
description: "Øv REGEXMATCH, REGEXEXTRACT og REGEXREPLACE i Google Sheets med regulære udtryk i et rigtigt regneark."
canonical_url: "https://excelopgaver.dk/sheets/opgaver/regex"
locale: da
meta:
  "og:description": "Øv REGEXMATCH, REGEXEXTRACT og REGEXREPLACE i Google Sheets med regulære udtryk i et rigtigt regneark."
  "og:image": "https://excelopgaver.dk/_og/d/c_Page%2Ctitle_Opgaver%2Bmed%2BREGEX-funktioner%2Bi%2BGoogle%2BSheets%2Cdescription_~w5h2IFJFR0VYTUFUQ0gsIFJFR0VYRVhUUkFDVCBvZyBSRUdFWFJFUExBQ0UgaSBHb29nbGUgU2hlZXRzIG1lZCByZWd1bMOmcmUgdWR0cnlrIGkgZXQgcmlndGlndCByZWduZWFyay4%2Ceyebrow_Google%2BSheets-opgaver%2Csite_excelopgaver%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTm90ZSIsIkhhciBldCB0YWwiXX0seyJuIjoyLCJjZWxscyI6WyJPcmRyZSAxMDAxIGFmc2VuZHQiLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9zaGVldHMvb3BnYXZlci9yZWdleCI%2Cs_ab3fP8UdFVMLvRJ_.png"
  "og:image:height": "600"
  "og:image:type": image/png
  "og:image:width": "1200"
  "og:title": "Opgaver med REGEX-funktioner i Google Sheets | ExcelOpgaver"
  "twitter:image": "https://excelopgaver.dk/_og/d/c_Page%2Ctitle_Opgaver%2Bmed%2BREGEX-funktioner%2Bi%2BGoogle%2BSheets%2Cdescription_~w5h2IFJFR0VYTUFUQ0gsIFJFR0VYRVhUUkFDVCBvZyBSRUdFWFJFUExBQ0UgaSBHb29nbGUgU2hlZXRzIG1lZCByZWd1bMOmcmUgdWR0cnlrIGkgZXQgcmlndGlndCByZWduZWFyay4%2Ceyebrow_Google%2BSheets-opgaver%2Csite_excelopgaver%2Cprops_eyJncmlkIjp7ImNvbHMiOlsiQSIsIkIiXSwicm93cyI6W3sibiI6MSwiY2VsbHMiOlsiTm90ZSIsIkhhciBldCB0YWwiXX0seyJuIjoyLCJjZWxscyI6WyJPcmRyZSAxMDAxIGFmc2VuZHQiLCIiXX1dLCJ0YXJnZXQiOlsxLDFdfX0%2Cp_Ii9zaGVldHMvb3BnYXZlci9yZWdleCI%2Cs_ab3fP8UdFVMLvRJ_.png"
---

> Index of every page on this site: [llms.txt](https://excelopgaver.dk/llms.txt)

# **Opgaver med REGEX-funktioner i Google Sheets**

Find, træk ud og erstat mønstre i tekst med REGEXMATCH, REGEXEXTRACT og REGEXREPLACE.

1. [1**Test tekst med REGEXMATCH**Brug REGEXMATCH i B2 til at tjekke, om noten i A2 indeholder et tal. Mønsteret \\d+ betyder ét eller flere cifre.](https://excelopgaver.dk/sheets/opgaver/regex/regexmatch)
2. [2**Træk et tal ud med REGEXEXTRACT****Premium**Brug REGEXEXTRACT i B2 til at trække ordrenummeret ud af noten i A2. Brug mønsteret \\d+.](https://excelopgaver.dk/sheets/opgaver/regex/regexextract-tal)
3. [3**Behold kun cifrene med REGEXREPLACE****Premium**Brug REGEXREPLACE i B2 til at fjerne alt i A2, der ikke er et ciffer. \\D (stort D) betyder ethvert tegn, der ikke er et ciffer.](https://excelopgaver.dk/sheets/opgaver/regex/regexreplace-cifre)

## **Funktioner i dette emne**

- [REGEXEXTRACT](https://excelopgaver.dk/sheets/funktioner/regexextract)
- [REGEXMATCH](https://excelopgaver.dk/sheets/funktioner/regexmatch)
- [REGEXREPLACE](https://excelopgaver.dk/sheets/funktioner/regexreplace)

```json
{"@context":"https://schema.org","@graph":[{"@id":"https://excelopgaver.dk/#identity","@type":"Organization","name":"ExcelOpgaver","url":"https://excelopgaver.dk/","logo":{"@id":"https://excelopgaver.dk/#logo"}},{"@id":"https://excelopgaver.dk/#website","@type":"WebSite","inLanguage":"da-DK","name":"ExcelOpgaver","url":"https://excelopgaver.dk/","publisher":{"@id":"https://excelopgaver.dk/#identity"},"translationOfWork":{"@id":"https://sheetgym.com/#website"}},{"@id":"https://excelopgaver.dk/sheets/opgaver/regex#webpage","description":"Øv REGEXMATCH, REGEXEXTRACT og REGEXREPLACE i Google Sheets med regulære udtryk i et rigtigt regneark.","name":"Opgaver med REGEX-funktioner i Google Sheets","url":"https://excelopgaver.dk/sheets/opgaver/regex","@type":["WebPage","CollectionPage"],"breadcrumb":{"@id":"https://excelopgaver.dk/sheets/opgaver/regex#breadcrumb"},"isPartOf":{"@id":"https://excelopgaver.dk/#website"},"potentialAction":[{"@type":"ReadAction","target":["https://excelopgaver.dk/sheets/opgaver/regex"]}],"primaryImageOfPage":{"@id":"https://excelopgaver.dk/#logo"}},{"@id":"https://excelopgaver.dk/sheets/opgaver/regex#breadcrumb","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","name":"Forside","item":"https://excelopgaver.dk","position":1},{"@type":"ListItem","name":"Google Sheets-opgaver","item":"https://excelopgaver.dk/sheets","position":2},{"@type":"ListItem","name":"Opgaver med REGEX-funktioner i Google Sheets","position":3}]},{"@id":"https://excelopgaver.dk/#logo","@type":"ImageObject","caption":"ExcelOpgaver","contentUrl":"https://excelopgaver.dk/brand/excelopgaver/icon-512.png","inLanguage":"da-DK","url":"https://excelopgaver.dk/brand/excelopgaver/icon-512.png"}]}
```

## Sitemap

See the full [sitemap](https://excelopgaver.dk/sitemap.md) for all pages.