Pulling 2/3 or 4 letter code from different locations

[Deano478]

Hi guys,

I'm currently doing some work a messy dataset and one job I've been asked to do is extract the 2/3 or 4 letter code from the data into a new column.

Regex was never my strongest point but I have it a go nonetheless to no avail. The Sample data I have had as structure like so:

ABC Testing for bugs

ZZ Test Home

ABC: Test scripts

CONS - Testing Rundown

The data will always be like this apart from these 4 variances there are no others

I appreciate this probably is a very easy or maybe undo-able task but I appreciate any help provided your saving me from insanity 😂

[Hammad_Rashid · Accepted solution]

Regex : \b([A-Z]{2,4})\b