# How to use hyperformulas

**URL:** <https://community.glideapps.com/t/how-to-use-hyperformulas/34038>\
**Category:** Ask for Help\
**Created:** [November 4, 2021, 10:59pm UTC](https://community.glideapps.com/t/how-to-use-hyperformulas/34038 "2021-11-04T22:59:55Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Keith\_Chikumbirike](https://avatars.discourse-cdn.com/v4/letter/k/5daacb/32.png) [@Keith\_Chikumbirike](https://community.glideapps.com/u/Keith_Chikumbirike)\
**Post date:** [November 4, 2021, 10:59pm UTC](https://community.glideapps.com/t/how-to-use-hyperformulas/34038/1 "2021-11-04T22:59:55Z")

</div>

I’m excited as I just discovered that you can now use excel formulas in glide tables. I am particularly happy about this as I am more familiar with spreadsheet formulas than database structures and coding.

However, I haven’t figured out how to input the formulas…  
I’m trying the following for example;  
_**=REGEXEXTRACT(A1,“[\[1\]]”)**_  
Do I just type it in because I did and assigned the column I want to substitute A1 for but nothing is happening…

* * *

1. :space:

---

<div class="post-metadata">

**Author:** ![david](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/david/32/62831_2.png) [@david](https://community.glideapps.com/u/david)\
**Post date:** [November 4, 2021, 11:13pm UTC](https://community.glideapps.com/t/how-to-use-hyperformulas/34038/2 "2021-11-04T23:13:33Z")

</div>

It looks like `REGEXEXTRACT` is not part of Hyperformula: [Built-in functions | HyperFormula (v1.3.0)](https://handsontable.github.io/hyperformula/guide/built-in-functions.html#list-of-available-functions)

It looks like `REGEXEXTRACT` is Google Docs only, and not part of Excel–maybe that’s why it’s not in Hyperformula. We should contribute it!

The `Extract Matching Text` column should do what you want.

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [November 5, 2021, 11:14pm UTC](https://community.glideapps.com/t/how-to-use-hyperformulas/34038/3 "2021-11-05T23:14:12Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.