Find & Replace

D

David

Greetings and tia for your help
I have a sheet full of lengthy supproduct formulas and wish to extend them all with a divide by 3 operation (/3)
Can this be done with FIND and REPLACE (ctrl + H), ie, find original string, replace with original string and "/3".
 
V

Vaughan

That would work if al the formulas are identical (including any references). If you have any relative references that vary down or across the sheet, you might try changing the display to RC form first.

Another way is to enter 3 in an empty cell, Copy, then select your formulas to be adjusted and Edit / Paste Special selecting Formula and Divide.
 
A

Ashish Mathur

Hi,

As replied by Vaughan, you may use the Paste special function. The problem with PAste special is that it does not show the formula i.e. it just shows ther result. You may also use the ASAP Utilities software to accolish this.

Regards,

Ashish Mathur
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Prompt For Replace in Selection And More... 0
WORD VBA Search and switch to advanced ... 1
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Visio: copy text of a master shape to User-define Cells (Variable) 0
find and replace numeric strings in larger text strings 8
Changing language from UK to US English 0
How to print two a6 booklets (A5 unfolded) on A4 paper? 3
find and replace formula text? 0

Top