Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

For example, if Column A contains:


I want to replace values with:


I know I could create another column to do something similar, but would rather know how to search and replace for this sort of pattern or drag and replace as one can do with other formula cells.

share|improve this question

Unfortunately, it isn't possible to reference "found" values in the replace box in Excel as you would do with regular expressions. There are plugins for Excel that do this (one example linked below, but there are many). I suggest you create a separate column with the values you want, then copy that column and paste values as needed - or use a plugin.

share|improve this answer

Do this in simple way:-

  1. In Column B, place this formula ="=("&A1&"/60)" in the Cell B1
  2. Double Click on + symbol at bottom right corner of the Cell B1
  3. Now updated formula is pasted in all cells under Column B
  4. Copy whole Column B and paste it on Notepad
  5. Once again select all CTRL+A and copy CTRL+C the formulas on Notepad
  6. Now select the Cell A1
  7. Paste the formulas

Now you will see all the formulas are updated as you expected in Column A

share|improve this answer

You can easily do this with a paste-special solution.

  1. Enter 60 in some cell.
  2. Copy that cell.
  3. Select the values in Column A, right-click, and choose 'Paste Special'.
  4. Choose 'Divide' under 'Operations'. Click OK.

If Column A holds values, the division will not show up as a formula, but rather as a simple value. E.g., 123 becomes 2.05 rather than =(123/60). However, if Column A contains formulas, the formulas will be amended to show the division. E.g., =SUM(B1:D1) becomes =SUM(B1:D1)/60.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.