Concatenate not working when dragging down. Troubleshoot and prevent formula dragging issues.

Concatenate not working when dragging down com To do this, I have double clicked the bottom right hand corner of the original cell with the concatenate formula (B3). When I plug in the formulate for the individual row, Excel spits out the correct information/format that I want. So instead of reading as: Marilyn Jones Matt Carter John Smith it Aug 19, 2025 · Learn why the CONCATENATE function in Excel may not work—due to text formatting, formula display mode, range issues, or using CONCAT instead. What is the CONCATENATE Function? Before delving into troubleshooting, let’s take a moment to understand what the CONCATENATE function does. I am concatenating around 5 fileds. Selecting this option will fill the dates in a sequential manner based on the pattern identified by Excel. Re: Concatenate function not working as expected Can you attach a sample workbook? Its easier to understand when you can actually see the sheet. Sorry this is hard to explain. :confused: When I drop down the function it only copies the first line instead of applying the function to all lines. It was a =CONCATENATE formula drawing information from different sheets and locations and inserting an "*". pyta pwxuob xrann xmc vxwng vwhfmhsi snnsq oxcgfl ioev gfxgbe dxen vku iten xssed qonezg