Hi,
Please help me with Formula how to remove the text after the last "-"
I've tried this but not working "=LEFT(A2,LEN(A2)-FIND("-",A2))"
Input Output
A013-ECO-15-88 A013-ECO-15
A013-ECO15-881 A013-ECO15
A013 ECO15-882 A013 ECO15
A013 ECO15 A013 ECO15
A013-ECO16 A013
Regards,
tt3
Bookmarks