Changing Formulas

B

B.G. - Canada

Right now I have the following

A1 =DATA!A3
B1 =DATA!B3
C1 =IF(DATA!C8=""."".DATA!C8)
D1 =IF(DATA!D8=""."".DATA!D8)

Is there any way to change the formulas in C1 & D1 to read
=IF(DATA!C3""."".DATA!C3) & =IF(DATA!D3=""."".DATA!D3) other than manually
changing them? Thanks in advance for any help!
 
S

Shane Devenshire

If you cange them to what you show they will not work! DATA!C1"" will return
an error.

On the other hand Select the cells C1:D1 and choose Edit, Replace, enter 8
in the Find What box and 3 in the Replace with box and click Replace All.
 

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

Top