Clear guidance to help you understand safe, effective aesthetic treatment options.
“Merge cells” and “combine columns” sound like they should be the same thing. They’re not — and mixing them up leads to either a spreadsheet that looks right but behaves badly, or a formula that doesn’t do what you thought it would.
Both tasks come up constantly. Here’s exactly how each one works, when to use it, and — importantly — when not to.
Merging cells is a visual formatting action. It takes two or more adjacent cells and turns them into one, which is useful for titles, section headers, or labels that need to span multiple columns.
To unmerge, select the merged cell and click Merge & Center again to toggle it off.
Merging cells looks clean and professional in the right context. In the wrong context, it’s a quiet disaster.
Inside a data range — meaning anywhere your data lives, not just titles and headers above it — merged cells break sorting, break filtering, and cause problems with PivotTables. Excel treats merged cells as a single entity, and when you try to sort or filter around them, things don’t behave the way you expect.
The rule is simple: merge cells for visual formatting that sits outside your data range. Titles, report headers, labels above a table — those are fine. Inside the data itself, leave cells unmerged.
This is a different operation entirely. Instead of changing how cells look, you’re joining the content of two cells into one — the most classic example being a First Name column and a Last Name column becoming a Full Name column.
In an empty column, type =A2&” “&B2. This takes the value in A2, adds a space, and attaches the value in B2. Copy the formula down and you’re done.
For more complex combinations — multiple columns, custom separators, or you need to skip blank cells — the TEXTJOIN function gives you more precision: =TEXTJOIN(” “,TRUE,A2,B2). The TRUE argument tells Excel to ignore empty cells, which is useful when some fields in your data aren’t always filled in.
The course was tailored to meet our needs. The instructor’s humor, patience, and knowledge made for an incredibly effective day.
Kathy Arnold
If the pattern is simple and consistent, Flash Fill is worth knowing about. Type the result you want in the first row of an empty column manually. Then press Ctrl+E. Excel looks at what you typed, figures out the pattern, and fills the rest of the column automatically — no formula required.
Flash Fill handles name combinations, phone number reformatting, pulling specific text out of a string — anything where the logic is visual and repetitive. It won’t work for every situation, but when it does, it’s faster than writing a formula and easier to explain to someone who doesn’t know Excel well.
Formatting and data combination are covered in CTS Excel courses at every level.
Reach out to Custom Training Services to build a training plan for your team.
Our team is here to guide you with clear, accurate answers to every concern.
Common Queries
Most patients recover within a few days, depending on the procedure and aftercare.
Most patients recover within a few days, depending on the procedure and aftercare.
Most patients recover within a few days, depending on the procedure and aftercare.
Most patients recover within a few days, depending on the procedure and aftercare.
Most patients recover within a few days, depending on the procedure and aftercare.
