I have a column in my query editor that I need to replace if a word is found in a cell. The column is all names that may have the text "- N/A" following. eg. "Bob Smith - N/A". I would like to be able to replace all the names that have "N/A" at the end of them with just the text "N/A". I am not sure if I have to make a new column or if this can be done another way.
Bookmarks