Formula Text String Help - Extract a sequence of numbers/letters from a text string

[Jonny99333]

Hi

I'm looking for a formula that will allow me to extract a specific sequence of numbers and letters within a long list of text strings which may appear anywhere within the text string - e.g.:

I need to find a text sequence LNNNN whereby L represents a letter and N represents a number

Heres a few examples of text strings whereby i would need a formula to extract this sequence. This text sequence could appear anywhere within the text string but will always appear after the character "-" but this character may appear numerous times within the text string:

Text Strings:

Cell A1: 564653-65341-EXPENSE-management35-G1234-4123
Cell A2: Account-R4321-SOFT4-cded-e23cxds
Cell A3: Company X example-46532testing-GRSFV-rwtgvwarsvw-123;juknbe23e-D4353-gsdbgv
Cell A4: Digital-645-A_22G534-Q4587

Results for required Formula from these text strings:

Result Cell A1: G1234
Result Cell A2: R4321
Result Cell A3: D4353
Result Cell A4: Q4587

Many thanks

Quote Reply
Report


J

 

[Fluff]

Duplicate to: ReExtract a sequence of texts and letters from a text string

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.