How to Combine Two Columns in Excel

{ "@context": "https://schema.org", "@type": "HowTo", "name": "How to Combine Two Columns in Excel", "description": "Follow these steps to combine two columns in Excel—such as first and last names—using the CONCAT function and a new column for your merged values.", "step": [ { "@type": "HowToStep", "name": "Locate the columns you want to merge", "text": "Start by locating the two columns that contain the data you want to merge, such as first and last names, IDs, or product codes." }, { "@type": "HowToStep", "name": "Insert a new column for your combined values", "text": "Highlight an adjacent column, right-click it, and select Insert to create a new column for your combined values." }, { "@type": "HowToStep", "name": "Enter the CONCAT formula", "text": "In the first row of your new column, type a formula like =CONCAT(A2, \" \", B2) to merge the contents of the two cells with a space in between, then press Return (Mac) or Enter (Windows)." }, { "@type": "HowToStep", "name": "Apply the formula to all rows", "text": "Click and drag the fill handle from the corner of the cell to apply the formula to all remaining rows." }, { "@type": "HowToStep", "name": "(Optional) Convert formulas to static values", "text": "You can convert the formula to static values by copying the entire column, right-clicking it, then selecting Paste Special > Values." } ] }