=LEFT(WELDS!A2,SEARCH("-FW",WELDS!A2)-1)
I have this formula right now but I want to add "-IN" where the fw is so that way if the data in a2 does not have fw but in it still works.
is there a way to do this for the same cell?