# 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> |
| --------- | ------------ |
| [<span class="NormalTextRun SCXW226194633 BCX8" style="margin: 0px; padding: 0px; user-select: text; -webkit-user-drag: none; -webkit-tap-highlight-color: transparent;">EXTRACT</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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>](/spreadjs/docs/v17/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 dynamic array function helps to extract the matching substring according to a regular expression.</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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;">MATCH</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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>](/spreadjs/docs/v17/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 helps to find whether the text matches a regular expression.</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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;">REPLACE</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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>](/spreadjs/docs/v17/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 replace part of a text string with a different text string using a regular expression.</span><span class="EOP SCXW226194633 BCX8" data-ccp-props="{201341983:0,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="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>