Substitute Function on all cells.

[Corpseblight]

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

[#3]

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