Search and replace Text Replace Formula

[Vonblack]

Hi All,

I'm seeking help off you good people. I'm trying to find a formula that will search for the "right" most "-" and return all characters to the left of it.

E.g.

PI-140568- would become PI-140568
PI-140573-17 would become PI-140573
PI-1991-2 would become PI-1991
PI-110869 would remain as PI-110869

Warm Regards and thanks in advance for any help.

[Pepe Le Mokko]

Perhaps =IFERROR(LEFT(A1,FIND("%",SUBSTITUTE(A1,"-","%",2))-1),A1)

[Vonblack]

Brilliant Pepe, Thank you ever so much.

[AlKey]

Or this

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

v	A	B
1	PI-140568	PI-140568
2	PI-140573-17	PI-140573
3	PI-1991-2	PI-1991
4	PI-110869	PI-110869

[Pepe Le Mokko]

There's more than one way to skin a cat...