RegEx expression

[sylvia0218]

Here is the description, the description is wrapped in one Excel cell. 

Legal Entity: ABC Inc. 

Account Name: ABC - JPM Chase account

Account #: 123456

ABA Routing #: 997889000

Currency: USD
Bank: JPM Chase

Bank Location: xxxxxxxxxxxxxxx

ID: xxxxxxxxxxxxx

How do I write the RegEx expression so that it extracts only the account number "123456" as my output? 

[Bren_Spill]

@sylvia0218 - see attached. I'm sure the regex experts on here could do a more efficient job!

[Qiu]

@sylvia0218 
If we dont use the RegEx tool 😁

[Raj]

@sylvia0218 use the following in formula tool:
REGEX_Replace([YourFieldName], ".*Account #: (\d+).*", "$1")

hope this helps.