I have a range of 2,185 cells I need to add text to in front of the contents
of each of the cells. I've tried the Search/Replace feature, trying to use
wildcards, but to no avail because it replaces the entire text. For
instance, I tried this:
Search for * and Replace with EBSCO:*. This put "EBSCO:*" in every cell,
which is not what I want. I want "EBSCO:xxx", with xxx being the 3-letter
code already there. Any advice would be greatly appreciated. Thank you!