I have a long spreadsheet (1780 lines) with columns A through G.

On all lines where there is a value for col. D, I would like to concatenate
columns D, E, and F into column G. If my formula is =CONCATENATE(D,E,F) it
doesn't work because I don't have the line numbers, but I can't format every
line with a separate formula. Is there a wildcard for the line numbers? Can I
have this formula apply to all lines of column G?
--
MichaelS