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.