I want to know if I can combine the Replace and right function in the same cell below is what I am trying to achieve I want to keep the title but change the last 4 characters with a new number in a separate row.
Current New Replacement number in separate row
4100-025-12 - Bottle Washer (72) 87
Desired outcome
4100-025-12 - Bottle Washer (87)
Thank you in advance I am sure it's easy, but I cannot come up with the correct sequence.
HR_Dude
Bookmarks