Use regex 2

[Steven_McKeering]

Hello

If you wanted a third option

Try this pattern:

(?<=VAT Registration Number)[A-Z]{2}[A-Z\d]+(?=Tax)
Preview the results here

Sample workflow:
Main.xaml (6.2 KB)

If you want to learn Regex - check out my Regex MegaPost: Regex help tutorial MEGAPOST – Making your first Regex post, Reusable Regex Patterns, Regex Troubleshooting, Sample Workflow and more

Cheers

Steve