Hi Caladbolg17
This won't answer your question, but more like re-phrase it, in hopes of the "formula boys" arriving on the scene.
The cells you are working with have values (ie: the text/words) something like this
Good & chr(10) & Great & chr(10) & Okay
and display the words in the cell one below the other. You would like to remove the word Okay.
Questions:
Is Okay the only word you ever want to remove?
Does the location of Okay change within the different cells?
If there are other words that need removed as well? If yes, are they in a list in the workbook somewhere?
Bookmarks