Forum Discussion
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.
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'.
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 Thank you so much, it worked like a charm!
I'm still learning excel so this fix made my day. Again, thanks a lot!
