Help with name matching formula

[SunValley]

Hello, I'm trying to correct the formula for column H. For example, in cell H13 I need this formula to only consider numbers and the point.
Notice that in H13 the result is "1.0A", when it should just be "1.0".

Also, in column H14, the result is "1.0 ", but it contains a space that can be noticed in F14, I would like the formula not to consider this space either, I think this could also be solved if only numbers and points were delivered.

Pasta1.xlsm
	E	F	G	H	I
12	Original name	New name	Extension	Name with dot and number only. After the first point, it should only contain 2 numbers
13	1.0A.png	1.0 .png	.png	1.0A
14	1.0 .png	1.0 .png	.png	1.0
Manter só gols e prioridade

Cell Formulas
Range	Formula
F13	F13	=D2&""&C2
F14	F14	=H14&""&G14
H13:H14	H13	=LEFT(E13,FIND(".",E13))&MID(E13,FIND(".",A2)+1,2)

 

[Peter_SSs]

Your formula in H13 refers to cell A2. We cannot see that cell and don't know what it has to do with the results.
Or perhaps A2 was a mistake and it should have been E13? If so, try

23 07 29.xlsm
	E	F	G	H
13	1.0A.png		.png	1.0
14	1.0 .png	1.0.png	.png	1.0
SunValley

Cell Formulas
Range	Formula
H13:H14	H13	=LET(c,MID(E13,SEQUENCE(LEN(E13)),1),TRIM(LEFT(CONCAT(IF(ISNUMBER(c+0),c,IF(c=".",c,REPT(" ",99)))),99)))

 

[SunValley]

Your formula in H13 refers to cell A2. We cannot see that cell and don't know what it has to do with the results.
Or perhaps A2 was a mistake and it should have been E13? If so, try

23 07 29.xlsm
	E	F	G	H
13	1.0A.png		.png	1.0
14	1.0 .png	1.0.png	.png	1.0
SunValley

Cell Formulas
Range	Formula
H13:H14	H13	=LET(c,MID(E13,SEQUENCE(LEN(E13)),1),TRIM(LEFT(CONCAT(IF(ISNUMBER(c+0),c,IF(c=".",c,REPT(" ",99)))),99)))

Thanks Peter, I actually forgot to change A2 to E13 in the formula. I didn't expect the modification to be so big and complex.

If there are any letters at the beginning of the name in column E, then the new formula in column H suspends the result instead of delivering only numbers. But what I'm working on now works perfectly, thanks for your help and patience friend

 

[SunValley]

Your formula in H13 refers to cell A2. We cannot see that cell and don't know what it has to do with the results.
Or perhaps A2 was a mistake and it should have been E13? If so, try

23 07 29.xlsm
	E	F	G	H
13	1.0A.png		.png	1.0
14	1.0 .png	1.0.png	.png	1.0
SunValley

Cell Formulas
Range	Formula
H13:H14	H13	=LET(c,MID(E13,SEQUENCE(LEN(E13)),1),TRIM(LEFT(CONCAT(IF(ISNUMBER(c+0),c,IF(c=".",c,REPT(" ",99)))),99)))

I forgot to mention, the first formula only delivers the first point, in the new formula it also delivers the second one, this is causing the extension point to be delivered, could you help me with that? the example is in column H15.

The formula should ignore beyond the first point regardless of whether they come from the extension or not.

Pasta1.xlsm
	E	F	G	H	I
12	Original name	New name	Extension	Name with dot and number only. After the first point, it should only contain 2 numbers
13	1.0A.png	1.0.png	.png	1.0
14	2 .png	2.png	.png	2
15	3.0.png	3.0..png	.png	3.0.
Manter só gols e prioridade

Cell Formulas
Range	Formula
F13	F13	=D2&""&C2
F14:F15	F14	=H14&""&G14
H13:H15	H13	=LET(c,MID(E13,SEQUENCE(LEN(E13)),1),TRIM(LEFT(CONCAT(IF(ISNUMBER(c+0),c,IF(c=".",c,REPT(" ",99)))),99)))

 

[Dave Patton]

With the limited examples that you showed, the following works.
You could also write the formula as follows
=LEFT(E16,MATCH(TRUE,ISERROR(VALUE(MID(E16,SEQUENCE(10),2))),0))

TextBefore.xlsm
	E	F	G		I
13	1.0A.png		.png		1.0
14	1.0 .png		.png		1.0
15	1.123B.xyz		.xyz		1.123
3a

Cell Formulas
Range	Formula
G13:G15	G13	=RIGHT(E13,4)
I13:I15	I13	=LEFT(E13,MATCH(1,--ISERROR(--(MID(E13,SEQUENCE(10),2))),0))

 

[SunValley]

With the limited examples that you showed, the following works.
You could also write the formula as follows
=LEFT(E16,MATCH(TRUE,ISERROR(VALUE(MID(E16,SEQUENCE(10),2))),0))

TextBefore.xlsm
	E	F	G		I
13	1.0A.png		.png		1.0
14	1.0 .png		.png		1.0
15	1.123B.xyz		.xyz		1.123
3a

Cell Formulas
Range	Formula
G13:G15	G13	=RIGHT(E13,4)
I13:I15	I13	=LEFT(E13,MATCH(1,--ISERROR(--(MID(E13,SEQUENCE(10),2))),0))

I tried the formula you provided, but notice that column H15 includes the extension point. The result should be "3.0", not "3.0."
Also the space in cell F14 is back, it should be "2.png", not 2 .png"

Pasta1.xlsm
	E	F	G	H	I
12	Original name	New name	Extension	Name with dot and number only. After the first point, it should only contain 2 numbers
13	1.0A.png	1.0.png	.png	1.0
14	2 .png	2 .png	.png	2
15	3.0.png	3.0..png	.png	3.0.
Manter só gols e prioridade

Cell Formulas
Range	Formula
F13	F13	=D2&""&C2
G13:G15	G13	=RIGHT(E13,4)
H13:H15	H13	=LEFT(E13,MATCH(1,--ISERROR(--(MID(E13,SEQUENCE(10),2))),0))
F14:F15	F14	=H14&""&G14

 

[Dave Patton]

Additional ideas that you can work with.
You can use Excel's Formula Formula Evaluate to review the formulas.
Define what must be excluded and edit the formula

TextBefore.xlsm
	E	F
12	Original name	New name
13	1.0A.png	1.0.png
14	2 .png	2.png
15	3.0.png	3.0.png
16
17
18	1.0A.png	1.0.png
19	2 .png	2.png
20	3.0.png	3.0.png
3aa

Cell Formulas
Range	Formula
F13:F15	F13	=LET(x,TRIM(LEFT(E13,MATCH(1,--ISERROR(--(MID(E13,SEQUENCE(10),2))),0))),IF(RIGHT(x,1)=".",LEFT(x,LEN(x)-1),x))&RIGHT(E13,4)
F18,F20	F18	=SUBSTITUTE(E18,"A","")
F19	F19	=SUBSTITUTE(E19," ","")

 

[SunValley]

Additional ideas that you can work with.
You can use Excel's Formula Formula Evaluate to review the formulas.
Define what must be excluded and edit the formula

TextBefore.xlsm
	E	F
12	Original name	New name
13	1.0A.png	1.0.png
14	2 .png	2.png
15	3.0.png	3.0.png
16
17
18	1.0A.png	1.0.png
19	2 .png	2.png
20	3.0.png	3.0.png
3aa

Cell Formulas
Range	Formula
F13:F15	F13	=LET(x,TRIM(LEFT(E13,MATCH(1,--ISERROR(--(MID(E13,SEQUENCE(10),2))),0))),IF(RIGHT(x,1)=".",LEFT(x,LEN(x)-1),x))&RIGHT(E13,4)
F18,F20	F18	=SUBSTITUTE(E18,"A","")
F19	F19	=SUBSTITUTE(E19," ","")

It worked fine, thanks a lot for your help and patience friend