Concatenate

[TheresaHowe]

I have not had issues with the concatenate function until now, everything used to work fine however, now, if I want to combine column A with column B using the concatenate function, when I grab the box on the bottom right to pull down for it to concatenate the entire column, everything shows up as the very first column.

I have attached the results, see column B.  Same thing happens if I want to use =Proper or =Trim, the function only recognizes row 2.

I do have windows 10 so I am not sure why I am unable to use this function any more, it worked fine yesterday.

[#2]

@TheresaHowe 

On the Formulas tab of the ribbon, in the Calculation tab, make sure that Calculation Options is set to Automatic.

[#3]

@Hans Vogelaar  thank you so much, that did the trick, what a life saver, the things you can do with Excel are endless, I need to learn more, again, thank you so much.