Need excel formulae to get first character than all data upto length as 8

[suraj8888]

Hi ,

Want Regex in excel formulae as mention below input and output for reference.

Input	Output
3005AB1394714000000	AB139471
2022ABR52447FPV	ABR52447
2022A9561554PPV	A9561554
2022ABR52240LTW	ABR52240
2022PAR45939FPV	PAR45939
2022PNN03733FPV	PNN03733
2019Z6167512	Z6167512
3895EU864DHI97554	DHI97554
3005O23243918900000	O2324391
30052011624051B10000004391	B1000000

 

[DanteAmor]

Hi and welcome to MrExcel.


Try:

=LET(p,A2,MID(p,MATCH(TRUE,ABS(CODE(MID(UPPER(p),SEQUENCE(LEN(p)),1))-77.5)<13,0),8))

Reference:

First Letter in a string

I have this formula that I need to modify a bit. Currently it takes the first character in a string and compares it to a cell I've called "Product_Specific". The Product_Specific cell will contain one letter (i.e. A, B, C, D, ect.) The formula sums up all of the rows that start with the...

www.mrexcel.com

 

[DanteAmor]

In case there are no letters in the cell:

=IFERROR(LET(p,A2,MID(p,MATCH(TRUE,ABS(CODE(MID(UPPER(p),SEQUENCE(LEN(p)),1))-77.5)<13,0),8)),"")

 

[Scott Huish]

It's clearly not just based on first letter because this value doesn't have an expected value starting with EU

3895EU864DHI97554

DHI97554

 

[Scott Huish]

If that's a mistake in the original post, then this should work:
=MID(A2,MIN(IFERROR(FIND(CHAR(64+SEQUENCE(26)),A2),1000)),8)