Can I search and replace within the Formula Bar?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am working in a worksheet with various numerical values in cells L2:P200.

In cell B5 I am adding cells M3+M19+M35+M51+M67+M83+M99+M115+M131+M147+M16
In cell D5 I am adding cells N3+N19+N35+N51+N67+N83+N99+N115+N131+N147+N16

However, when I paste cell B5 into D5 the results are O3+O19+O35+O51+O67+O83+O99+O115+O131+O147+O163
I am trying to find out if there is a more efficient way to replace the "O"s with "N"s.

Got any suggestions?
 
You can search and replace on one cell (just select the cell, don't touch
the formula bar), and it will change the Os to Ns.

Alternatively, you can select the formula from the formula bar, CTRL-C to
copy it, then paste it into another cell with CTRL-V and it wont change the
cell refs.
 
Back
Top