Hi! I am trying to find a resolution to replace certain text / codes within a cell. I tried several different codes but I cannot figure out what I am doing wrong as it is not finding the text. I tried "substitute" and "replacetexts" but my file is rather large and it only picked up a few codes here and there (probably user error). Here is a small sample of what I am working with if anyone has any suggestions. Thank you for your time!
Bookmarks