extract 3 letter acronym and numbers from text

[bisntrix]

Hello,

I am trying to extract a 3 letter acronym along with numbers from text cell that could vary in length. So for example, the tla could look like one of the following

ECU
BTU
NJM

The numbers would follow this TLA with a space between. Number format could look like the following

123.11
1234.13
12345.14
123456.15

So end result, example to extract could look like

ECU 123456.12
BTU 123.22

Letters or numbers could be any combination, and could be positioned anywhere in the text. Just don't know how to get started. Thanks in advance.

[Jakobshavn]

Post specific examples of the full records.

[bisntrix]

Hello, here are 3 examples below. I highlighted in bold what I'd like to be extracted and put in another cell. thank you

Code CCU 2613.01 (Axle lube trop basse)

'ENGINE DRATES AND CODE ECU 2659.03 ACTIVE F OR EGR

'Red Alert for RED CCU 002613.01 Axle L ube System - Axle Lube Pressure below acceptable level

[event21]

Hi -

Use TextToColumns

Regards,
Event

[FDibbins]

you provided some good examples, but could you show what your expected outcome is? it may be crystal clear to you, but not to all of us

[Ghozi Alkatiri]

use array formula ie data at A1

=MID(A1;MIN(IF(ISNUMBER(--MID(A1;ROW($1:$100);1));ROW($1:$100)))-4;COUNT(--MID(A1;ROW($1:$100);1))+5)

[icestationzbra]

this non-array formula assumes that you will have either of CCU, ECU, BTU or NJM in a string and that the string is fewer than 255 characters long:

Please Login or Register  to view this content.