Here we go ? When to Use CONCATENATE Function in ExcelĬONCATENATE formula in excel is a useful function to combine/join values, texts, numbers, and strings in two or more cells into one single excel cell. Use the '&' symbol as a replacement for Concatenate. 4 # Combine Numbers in Excel Using CONCATENATE formula 3 # Combining Text with Formula Result in Excel 3 # Combining Cell Value and Text Characters
2 # Combining Cell Values Using Cell Reference
1 # Combining Texts/Words in Excel using CONCATENATE Function I can just drag the formula down to extend it to all other cells and. Excel will combine the text in cells A2 and B2 and output a finished, compound word in C2. I used a basic '&' formula to join A2 and B2, and then dragged it down to combine each compound word.