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.
--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"B.G. - Canada" wrote:

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!