SOLVED

Substitute Function on all cells.

Copper Contributor

Hello, I'm new here and this is my first post.
I have the function =SUM(B3:C3)-(D3*6) on a column and I need to replace the whole D column with *1 instead of *6 at the end while keeping the rest of the function. Is there a way to substitute it on the whole worksheet without draggin down the corrected function? It's a LOT of columns and it's taking too much time.
Sorry for my english and thanks in advance.

2 Replies
best response confirmed by Corpseblight (Copper Contributor)
Solution

@Corpseblight 

Do you have occurrences of *6) in formulas that you do NOT want to be changed to *1) ?

If not:

  • Select the entire range for which you want to do this,
  • Press Ctrl+H to activate the Replace dialog.
  • Enter ~*6) in the 'Find what' box.
  • Enter *1) in the 'Replace with' box.
  • Click 'Replace All'.

HansVogelaar_0-1711649875349.png

@Hans Vogelaar Thank you so much, it worked like a charm!
I'm still learning excel so this fix made my day. Again, thanks a lot!

1 best response

Accepted Solutions
best response confirmed by Corpseblight (Copper Contributor)
Solution

@Corpseblight 

Do you have occurrences of *6) in formulas that you do NOT want to be changed to *1) ?

If not:

  • Select the entire range for which you want to do this,
  • Press Ctrl+H to activate the Replace dialog.
  • Enter ~*6) in the 'Find what' box.
  • Enter *1) in the 'Replace with' box.
  • Click 'Replace All'.

HansVogelaar_0-1711649875349.png

View solution in original post