SOLVED

# Substitute Function on all cells.

Copper Contributor

# Substitute Function on all cells.

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

# Re: Substitute Function on all cells.

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'.

# Re: Substitute Function on all cells.

@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

# Re: Substitute Function on all cells.

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'.