trim formula

[luvbite38]

Hi guys,

is there a simple formula to convert "67673263-FB10-4231-A60D-4B5354674041_photo-1742912936.jpeg.jpg" into 1742912936?

Please help


Thanks in advance
LB

 

[Oeldere]

CTRL + H

Find *photo-
Replace all (leave blanc)


After that
Find .jp*
Replace all (leave blanc)

 

[Matt Rogers]

1a !!!

 

[Oeldere]

@Matt Rogers

What does 1a !!! means?

 

[Matt Rogers]

1a = excellent
1b = very good
1c = fine
...
...

 

[Rick Rothstein]

You can do it with less characters in the "Find what" field...

CTRL + H

Find *photo-
Replace all (leave blanc)

Just an asterisk and a dash...

Find: *-

After that
Find .jp*
Replace all (leave blanc)

Just a dot and an asterisk....

Find: .*

 

[taurean]

If your sample is correct representation of all data you have then:
=TRIM(RIGHT(SUBSTITUTE(LEFT(SUBSTITUTE(A1,".",REPT(" ",100)),100),"-",REPT(" ",100)),100))
should work.

 

[Rick Rothstein]

If your sample is correct representation of all data you have then:
=TRIM(RIGHT(SUBSTITUTE(LEFT(SUBSTITUTE(A1,".",REPT(" ",100)),100),"-",REPT(" ",100)),100))
should work.

A different, but similarly constructed, formula that also works...

=TRIM(MID(SUBSTITUTE(RIGHT(SUBSTITUTE(A1,"-",REPT(" ",300)),300),".",REPT(" ",300)),1,300))

 

[taurean]

Yeah. In fact if there are no leading zeroes then this will work as well
=RIGHT(SUBSTITUTE(LEFT(SUBSTITUTE(A1,".",REPT(" ",100)),100),"-",REPT(" ",100)),100)+0

 

[Oeldere]

@Matt Roger,

Thanks for the reply and explaination.

Thanks for the compliment.