Combining names in Google Sheets is a common task when cleaning contact lists, employee records, customer databases, or signup forms. If first names and last names are stored in separate columns, a simple formula can join them into one full name column.

The best method depends on your spreadsheet layout and how much data you need to process. You can use the ampersand operator, CONCATENATE, TEXTJOIN, ARRAYFORMULA, or smart cleanup formulas when your data includes blanks or extra spaces.

This guide shows how to combine first and last name in google sheets in practical ways. You will learn quick formulas, cleaner methods for large lists, and useful fixes for common formatting problems.

Basic Formula With Ampersand

The fastest way to combine first and last name in Google Sheets is by using the ampersand symbol. If the first name is in cell A2 and the last name is in cell B2, you can join both values in another column.

Use this formula in cell C2: =A2&” “&B2. The quotation marks add a space between the two names, so the result looks like “Sarah Johnson” instead of “SarahJohnson.” This method is simple and easy to remember.

After entering the formula, drag it down the column to apply it to the rest of your rows. This works well for small spreadsheets, quick cleanup tasks, and lists where every row has both a first name and a last name.

Using CONCATENATE for Full Names

CONCATENATE is another standard way to combine text values in Google Sheets. It joins multiple pieces of text into one result, including names, spaces, punctuation, or other labels you want to include in the final output.

For example, use =CONCATENATE(A2,” “,B2) to combine the first name from A2 and the last name from B2. The space inside quotation marks creates a natural gap between both name fields.

This method is clear for users who prefer named functions instead of symbols. It also works well when training team members because the formula name describes what the function does inside the spreadsheet.

Quick Formula Options

• Ampersand formula: =A2&" "&B2

• CONCATENATE formula: =CONCATENATE(A2," ",B2)

• TEXTJOIN formula: =TEXTJOIN(" ",TRUE,A2,B2)

• ARRAYFORMULA option: =ARRAYFORMULA(A2:A&" "&B2:B)

• Cleaner output: =TRIM(A2&" "&B2)

Using TEXTJOIN for Cleaner Results

TEXTJOIN is often the most flexible formula for combining names in Google Sheets. It lets you choose a separator, skip blank cells, and join several text values without creating awkward extra spaces in the result.

Use =TEXTJOIN(” “,TRUE,A2,B2) when first names are in column A and last names are in column B. The first part sets the separator as a space, and TRUE tells Google Sheets to ignore empty cells.

This is helpful when some rows have missing last names, middle names, or partial data. Instead of returning extra spaces, TEXTJOIN creates a cleaner full name and keeps your spreadsheet easier to scan.

Combining Names With Middle Names

Some spreadsheets include first names, middle names, and last names in separate columns. In that case, you can still use the same logic, but you need to include the middle name column in the formula.

If first names are in A2, middle names are in B2, and last names are in C2, use =TEXTJOIN(” “,TRUE,A2:C2). This formula combines all available name parts and skips any blank middle name cells.

TEXTJOIN is usually better than ampersand formulas for this setup because it avoids double spaces. That makes it useful for directories, student records, HR sheets, event registrations, and customer relationship management exports.

Best Practices for Name Columns

• Keep first name, middle name, and last name in separate source columns.

• Create a new full name column instead of overwriting original data.

• Use TEXTJOIN when some name fields may be blank.

• Use TRIM to remove extra spaces from imported lists.

• Copy and paste values when you no longer need live formulas.

Using ARRAYFORMULA for an Entire Column

ARRAYFORMULA helps you combine names across an entire column without dragging formulas row by row. This is useful when your sheet keeps growing through form submissions, imports, or shared team updates.

Place this formula in C2: =ARRAYFORMULA(IF(A2:A=””,””,A2:A&” “&B2:B)). It combines names for every row where column A has a value and leaves empty rows blank.

This approach saves time in large spreadsheets. It also reduces formula errors because you only manage one formula at the top of the result column instead of hundreds or thousands of copied formulas.

Removing Extra Spaces With TRIM

Imported spreadsheets often contain extra spaces before, after, or between names. These spaces can create messy full names and cause problems when sorting, filtering, matching, or importing data into another platform.

Use =TRIM(A2&” “&B2) to combine names while cleaning unnecessary spacing. TRIM removes leading spaces, trailing spaces, and repeated spaces between words, giving you a more polished full name result.

TRIM is especially helpful when data comes from forms, CRMs, CSV files, or manual entry. Clean names look more professional and reduce errors in email campaigns, mail merges, reports, and contact exports.

Helpful Cleanup Formulas

• Remove extra spaces: =TRIM(A2&" "&B2)

• Join and skip blanks: =TEXTJOIN(" ",TRUE,A2,B2)

• Combine full row parts: =TEXTJOIN(" ",TRUE,A2:D2)

• Convert formula output to fixed text using Paste special, Values only.

• Review imported data before deleting source columns.

Combining Names in Reverse Order

Sometimes you may need names in “Last Name, First Name” format. This format is common in academic records, filing systems, legal lists, membership databases, and reports sorted alphabetically by last name.

If first name is in A2 and last name is in B2, use =B2&”, “&A2. The comma and space inside quotation marks create a clean result such as “Johnson, Sarah.”

You can also use =TEXTJOIN(“, “,TRUE,B2,A2), though this adds the comma separator between both values. Choose the format that matches your reporting system or export requirements.

Creating Full Names From Split Data

If your spreadsheet already has full names but you need separate first and last name columns, Google Sheets can split the data first. After splitting, you can recombine names in a cleaner or standardized format.

Use Data, Split text to columns when names are separated by spaces. This creates separate columns from one full name field, although complex names may need manual review when they include prefixes or multiple surnames.

Once the data is split, you can rebuild the full name with a formula. This gives you more control over capitalization, spacing, middle initials, suffixes, and the final format used for reports or exports.

Internal Resource for Spreadsheet Cleanup

For more spreadsheet cleanup methods, review our guide on Google Sheets data cleaning. It pairs well with name-combining formulas because clean source data leads to better formulas, fewer duplicates, and more reliable exports.

You can also use a guide on Google Sheets text formulas when working with contact lists. Functions like LEFT, RIGHT, SPLIT, PROPER, TRIM, and TEXTJOIN help organize names, addresses, titles, and mixed text fields.

Internal links should support the reader’s task naturally. A keyword-based link such as Google Sheets data cleaning or Google Sheets text formulas fits this topic without distracting from the main goal.

Using PROPER for Name Capitalization

Name data often arrives in inconsistent capitalization, such as all caps, all lowercase, or mixed formats. Google Sheets can standardize many of these cases with the PROPER function, which capitalizes the first letter of each word.

Use =PROPER(A2&” “&B2) to combine names and apply title-style capitalization. For example, “sarah johnson” becomes “Sarah Johnson,” which looks cleaner in directories, email lists, and printed reports.

PROPER is useful, but it may not handle every name perfectly. Names such as “McDonald,” “O’Neil,” or “van Buren” may need manual review depending on your formatting standards and audience expectations.

Combining Names With Titles and Suffixes

Some records include titles, prefixes, or suffixes, such as Dr., Ms., Jr., or III. You can combine these fields with first and last names, but you should choose a formula that handles blanks cleanly.

If title is in A2, first name in B2, last name in C2, and suffix in D2, use =TEXTJOIN(” “,TRUE,A2:D2). This joins every available part and skips blank cells.

This method works well for formal contact lists, certificates, invitations, patient records, and professional directories. It keeps formatting consistent while reducing the need for separate manual edits across many rows.

Common Mistakes to Avoid

• Forgetting the space between first and last name.

• Overwriting original name columns too early.

• Dragging formulas inconsistently across large sheets.

• Ignoring blank cells that create extra spaces.

• Using formulas without checking imported data quality.

• Forgetting to paste values before exporting final data.

Copying Formula Results as Values

Formula results change when source cells change. That is useful while editing, but it can create problems when exporting, sharing, or deleting the original first name and last name columns.

To keep full names as fixed text, copy the formula results and use Paste special, Values only. This replaces formulas with the actual displayed names, so the full name column no longer depends on source columns.

This step is important before sending files to another system, uploading a CSV, or removing helper columns. It prevents broken references and keeps the final spreadsheet stable for future use.

Choosing the Right Formula

The ampersand method is best for quick work when every row has complete data. It is short, readable, and ideal for small lists where missing names or extra spacing are not major concerns.

TEXTJOIN is better for cleaner spreadsheets and mixed data. It handles blanks more gracefully, works with several columns, and keeps formulas easier to manage when middle names, titles, or suffixes are involved.

ARRAYFORMULA is best for large or growing sheets. When paired with IF logic, it automatically fills results for new rows and keeps empty rows clean, which is useful for form responses and shared databases.

Practical Workflow for Large Contact Lists

Start by reviewing your source columns before adding formulas. Check whether names have extra spaces, inconsistent capitalization, missing values, duplicate records, or mixed formats that could affect your final full name column.

Next, create a new column called Full Name. Use TEXTJOIN or ARRAYFORMULA depending on the size of your sheet. Add TRIM or PROPER when your source data needs cleanup before export or reporting.

Finally, inspect the results, copy the full name column, and paste values if the data is ready. Keep the original first and last name columns until you confirm the final output is correct.

Example Spreadsheet Layout

A practical setup uses column A for First Name, column B for Last Name, and column C for Full Name. This layout is simple, readable, and compatible with most contact exports.

In C2, enter =TEXTJOIN(” “,TRUE,A2,B2). Then fill the formula down, or use ARRAYFORMULA if the spreadsheet contains many rows or receives new entries from a form.

This layout also keeps your original data intact. If you need to fix a misspelled first name or last name later, the full name column updates automatically while the formula remains unchanged.

When to Use Manual Editing

Formulas handle most name-combining tasks, but manual editing still matters for unusual names. Some records include compound surnames, professional initials, cultural naming patterns, or suffixes that do not fit a simple two-column structure.

Manual review is also useful when preparing official documents, certificates, contracts, or personalized communications. A formula can speed up the process, but human review helps prevent awkward or incorrect name formatting.

For routine marketing lists or internal reports, formulas usually provide enough accuracy. For formal communications, combine formula automation with a final review so the finished spreadsheet respects each person’s name.

Conclusion

Combining first and last names in Google Sheets is simple once you choose the right formula. The ampersand method works for quick lists, CONCATENATE is easy to read, TEXTJOIN handles blanks cleanly, and ARRAYFORMULA supports large datasets.

For cleaner results, use TRIM to remove extra spaces and PROPER to improve capitalization when needed. Keep original name columns until your full name column has been reviewed, then paste values if you need fixed text.

The best way to handle how to combine first and last name in google sheets is to match the formula to your data. Small lists need simple formulas, while larger or messy sheets benefit from TEXTJOIN, ARRAYFORMULA, and cleanup functions.

FAQ

What is the easiest formula to combine first and last name in Google Sheets?

The easiest formula is =A2&” “&B2. It joins the first name in A2 with the last name in B2 and adds a space between them. This works well when both cells contain clean, complete name data.

How do I combine names without extra spaces?

Use =TEXTJOIN(” “,TRUE,A2,B2). TEXTJOIN skips blank cells and uses a space only where needed. This is better than a basic ampersand formula when some rows have missing first names, last names, or middle names.

Can I combine names for an entire column automatically?

Yes, use ARRAYFORMULA. A useful option is =ARRAYFORMULA(IF(A2:A=””,””,A2:A&” “&B2:B)). It fills the full name column automatically for rows with data and keeps blank rows empty.

How do I combine first, middle, and last names?

Use =TEXTJOIN(” “,TRUE,A2:C2) when first, middle, and last names are in columns A, B, and C. This formula joins available name parts and skips blank cells, which helps when some people have no middle name.

How do I make combined names look properly capitalized?

Use PROPER with your combining formula, such as =PROPER(TEXTJOIN(” “,TRUE,A2,B2)). It capitalizes each word in the result. Review special names manually because some capitalization patterns may need personal or cultural accuracy.