I am trying to find a way to replace one portion of a series of formulas. In order to copy the formula throughout the worksheet and to allow cell references to change accordingly, I used the cell dragging technique.
Now however, I want to wrap the quote (") character around these cell references but I'm having a hard time with it.
In the Search field of the search and replace dialog, I seem to be able to use a wildcard to locate the correct cell reference I'm after, but if I use a wildcard in the Replace field, it replaces the cell number with the wildcard.
For instance, using K* in the Search field finds all cell references from K5 through K100 but the replace function (using "K*" as my replace data) makes every reference equal to "K*". I'd like to keep the cell number so I end up with "K5", "K6",..."K99", "K100", etc.
Bookmarks