I want to create a formula a formula that will convert codes into text. Column A will have numbers like 911127-01, 911127-02 and 911127-03. I need a formula that will change every cell that contains 911127-01 will change into "Morning" the cells that contain 911127-02 will change into "Afternoon" and the ones that contain 911127-03 change into "evening".
please help.
Bookmarks