# Regex substring formula

Hi! I want to create a formula that returns the partial match of a string given a regex like this **^[A-Z] [0-9]** which will find and return

**KA7030**in the formula column. Is that possible?

This is an example dataset

```
KA7030ROJO1
KA7030ROJO2
KA7030ROJO3
KA7030ROJO4
KA7050PIEL4
```