Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • How to get last row in mixed data with blanks in Excel
  • How to reference named range different sheet in Excel
  • Find Closest Match in Excel Using INDEX, MATCH, ABS and MIN functions
  • How to use Excel TRANSPOSE Function
  • Multi-criteria lookup and transpose in Excel

Data Analysis Examples

  • How to create Checklist in Excel
  • Reverse List in Excel
  • How to create a Histogram in Excel
  • How to create running total in an Excel Table
  • How to calculate correlation coefficient Correlation in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation number multiple 100
  • Prevent invalid data entering in specific cells
  • Excel Data validation don’t exceed total
  • Excel Data validation exists in list

Join first and last name — Manipulating NAMES in Excel

by

If you need to join separate first and last names together into a single full name, you can easily do so with concatenation using the ampersand (&) character. In the formula below, first is first name, and last is last name.

Formula

=first&" "&last

Explanation

In the example, the active cell contains this formula:

Worked Example:   Join Text Strings Using Concatenate or '& Operator' in Excel
=B4&" "&C4

How this formula works

The ampersand character (&) is a special operator in Excel that is used for concatenation. Concatenation is just a fancy word for “join”.

On the formula, the text in B4 “Susan” is being joined to a space character ” ” and then to the text in cell C4, “Chang”.

Worked Example:   CONCATENATE function: Description, Usage, Syntax, Examples and Explanation

Whenever you use concatenation with literal text entered directly inside the formula, make sure to enclose the text in double quotes (“”). The ampersands are never enclosed in quotes unless you want an ampersand to appear in the result of a formula as literal text.

Worked Example:   CONCATENATE function: Description, Usage, Syntax, Examples and Explanation

With CONCATENATE

You can also use the CONCATENATE function to join text. For this example, the formula would be:

=CONCATENATE(B4," ",C4)

The CONCATENATE function keeps things tidy, but the ampersand creates shorter, more flexible formulas.

Post navigation

Previous Post:

Extract middle name from full name — Manipulating NAMES in Excel

Next Post:

Put names into proper case — Manipulating NAMES in Excel

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • Split numbers from units of measure in Excel
  • How to count total words in a range in Excel
  • How to extract text between parentheses in Excel
  • Remove line breaks in a cell in Excel
  • How to calculate Number of Instances in Excel
  • Calculate number of hours between two times in Excel
  • Get work hours between dates custom schedule in Excel
  • Excel Date & Time Functions Example
  • Convert date to month and year in Excel
  • Get day from date in Excel
  • How to calculate simple interest in Excel
  • TBILLEQ function: Description, Usage, Syntax, Examples and Explanation
  • COUPNUM function: Description, Usage, Syntax, Examples and Explanation
  • PDURATION function: Description, Usage, Syntax, Examples and Explanation
  • COUPDAYBS function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles