Seperate data containing Numerics in Col A

[Howardc1001]

I have data in Col A. I need a formula to extract the data in Col A where the Alpha just before the first numeric must contain a space for eg BR1PEB128 to look like this BR1PE B128


See attached sample data


Your assistance is most appreciated

[Pepe Le Mokko]

What is the logic?

[Fluff13]

Maybe change this in your original code

Please Login or Register  to view this content.

[Howardc1001]

Thanks Fluff

[Howardc1001]

Hi Pepe

The first Alpha before the number is the cell address

[Fluff13]

You're welcome & thanks for the feedback