It sounds like your formula has absolute references and needs relative
references. Absolute references are shown by dollar signs before the column
and/or row references within the formula. Remove the dollar signs and try
filling down again.

Hope this helps,

Hutch

"Harry Hornet" wrote:

I have a names and address file that has house numbers and street names in
separate cells.
I need to merge them so that they are in the same cell with a space between
them.
I have used CONCATENATE and I have had success with the first record.
However when I try to use the fill handle to populate down the rest of the
records, the same result is returned.
The formula in the cell is correct and if I click on it then the function
symbol, the correct result is then displayed.
I am not sure if I have explained this very well but if someone can help I
would be grateful.