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.
You have posted in a Word forum. Is this correct?
Quoting entire posts clutters the forum and makes threads hard to read !
If you are pleased with a member's answer then use the Star icon to rate it
Click here to see forum rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks