Changing Formulas

  • Thread starter Thread starter B.G. - Canada
  • Start date Start date
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!
 
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

Similar Threads

Excel Help to copy information from one row at a time to another sheet 1
read only and write only 2
Protecting user from changing previous data 5
Excel functions 0
Adding values in to table for appropriate fields only 5
Vlookup and multiple data 5
Worksheet program to convert parent/children data to string(s) 1
Stripe out duplicate data 5

Back
Top