Reg Ex Formula to extract numbers

[RCOOK]

I would like the regex expression to remove numbers from text and create a new column with the store number. Below are a few examples.

FHFAberdeen248

FHFAdamsville205

FHFAdel124

FHFAiken61

FHFSoperton1

[DataNath · Accepted solution]

Hey @RCOOK are the store names always in this format? If so, could use this:

(\D+)(\d+)

[Robin_McIntosh · Accepted solution]

[Matthew · Accepted solution]

REGEX_Replace([Field1], '(\d+?)$|.*?', '$1')

[RCOOK]

Thanks so much!! Big Help

[RCOOK · Accepted solution]

Excellent thanks so much Dan!

[RCOOK · Accepted solution]

Thanks Matthew!