How to Parse out text&number codes

[rwicker]

Hello,

I have the data below and need to parse out what is bold. I feel that this is simple but cannot wrap my head around it.  Thanks!

ReturnByDea FC2545537 Not load for DM CABP655270 remitDea RW0231908|

There is a long list that have different codes for each row.

[CharlieS · Accepted solution]

I was able to parse out the desired strings using the following RegEx:

(\<\u+\d+\>)

Expression breakdown:

(               )   Define the expression

 \<         \>    Word string, meaning a string of characters bound by a space character on both sides

    \u+           One or more uppercase characters

         \d+      One or more number (digit) characters