Concatenate

%3CLINGO-SUB%20id%3D%22lingo-sub-1724224%22%20slang%3D%22en-US%22%3EConcatenate%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1724224%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20not%20had%20issues%20with%20the%20concatenate%20function%20until%20now%2C%20everything%20used%20to%20work%20fine%20however%2C%20now%2C%20if%20I%20want%20to%20combine%20column%20A%20with%20column%20B%20using%20the%20concatenate%20function%2C%20when%20I%20grab%20the%20box%20on%20the%20bottom%20right%20to%20pull%20down%20for%20it%20to%20concatenate%20the%20entire%20column%2C%20everything%20shows%20up%20as%20the%20very%20first%20column.%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20results%2C%20see%20column%20B.%26nbsp%3B%20Same%20thing%20happens%20if%20I%20want%20to%20use%20%3DProper%20or%20%3DTrim%2C%20the%20function%20only%20recognizes%20row%202.%3C%2FP%3E%3CP%3EI%20do%20have%20windows%2010%20so%20I%20am%20not%20sure%20why%20I%20am%20unable%20to%20use%20this%20function%20any%20more%2C%20it%20worked%20fine%20yesterday.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1724224%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

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 Replies
Highlighted

@TheresaHowe 

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

Highlighted

@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.