use this formula in column G:
=if($D1<0,concatenate(D1,E1,F1),"")

What this means is that if D is not blank, then concatenate. If it is
blank, do nothing.

"MichaelS" wrote:

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