Formula to Delete Text Between 2 Characters

Hi,

I have the following string 12345_123_6789 and I need to get to 12345_6789, in there a way I can do this with a single formula, or do I have to split to multiple cells and concatenate?

Thanks

Try

=REPLACE(A1,FIND("_",A1),FIND("_",A1,FIND("_",A1)+1)-FIND("_",A1),"")