Changing Formulas

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

 

[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 C11 and choose Edit, Replace, enter 8
in the Find What box and 3 in the Replace with box and click Replace All.

 

[B.G. - Canada]

This will speed things up, Thanks Shane!