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