# RegEx Functions

## Content

<span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">Spread provides the following RegEx functions, listed alphabetically.</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,335559739:160,335559740:259}" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; font-size: 11pt; line-height: 19.425px; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif;"> </span>

| **<span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">Function</span>**<span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,335551550:2,335551620:2,335559740:259}" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; font-size: 11pt; line-height: 19.425px; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif;"> </span> | **<span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">Description</span>**<span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,335551550:2,335551620:2,335559740:259}" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; font-size: 11pt; line-height: 19.425px; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif;"> </span> |
| --------- | ------------ |
| [REGEXEXTRACT](/spreadjs/docs/formulareference/FormulaFunctions/regex-functions/extract) | <span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">This function </span><span style="color: rgb(41, 42, 46); font-family: ui-sans-serif, -apple-system, BlinkMacSystemFont, 'Segoe UI', Ubuntu, 'Helvetica Neue', sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: pre-wrap; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">extracts text from a string based on a specified regular expression. It supports extracting the first match, all matches, or capturing groups from the first match.</span> |
| [<span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">REGEXTEST</span>](/spreadjs/docs/formulareference/FormulaFunctions/regex-functions/match) | <span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">This function allows you to check whether any part of the supplied text matches a regular expression ("regex"). It returns TRUE if it does, and FALSE if it doesn't.</span> |
| [REGEXREPLACE](/spreadjs/docs/formulareference/FormulaFunctions/regex-functions/replace) | <span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">This function helps to </span><span style="color: rgb(41, 42, 46); font-family: ui-sans-serif, -apple-system, BlinkMacSystemFont, 'Segoe UI', Ubuntu, 'Helvetica Neue', sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: pre-wrap; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial; display: inline !important; float: none;">replaces text in a string based on a specified regular expression pattern.</span> |

<span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,335559739:160,335559740:259}" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent; font-size: 11pt; line-height: 19.425px; font-family: Calibri, Calibri_EmbeddedFont, Calibri_MSFontService, sans-serif;"> </span>