• About
  • Contact
  • Privacy Policy
  • Submit For Review
  • Template Gallery
  • Excel 2016 Udemy Course
  • Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

TheAppTimes

App Reviews, Tutorials, & Gadget News Hub

  • Gadgets
  • How To
  • Mobile Apps
  • Software and Web Apps
  • Buying Guides
  • Show Search
Hide Search
Home » How To » How to Combine the Contents of Multiple Cells in Excel [Method 3 is Super Easy]

How to Combine the Contents of Multiple Cells in Excel [Method 3 is Super Easy]

June 16, 2016

There may be times when you need to combine the contents of multiple cells in your Excel worksheet to arrive at a single name. For instance you may have a salutation, a first name and a second name, which appear in three different columns in your worksheet and you may want to combine them into displaying as one name in another column. You can do this by using a simple function in Excel called Concatenate or by a far more easier method that doesn’t even require formulas or functions.

Note: This activity was performed on a Windows 10 PC in Excel 2016.

How to Combine the Contents of Multiple Cells in Excel

Method 1

In my example worksheet, I have the salutation in column A, the first name in column B, the second name in column C and I want to output the full name in column D.

How to Combine the Contents of Multiple Cells in Excel

For this in cell D2, I will input the function:

=CONCATENATE(A2, ” “, B2, ” “, C2)

The result of such a function is that Excel combines the values from each of the specified cells and places a space between them.

Method 2

You can also write the same concatenation formula using ampersand as shown below:=A2 & ” ” & B2 & ” ” & C2

How to Combine the Contents of Multiple Cells in Excel Using Ampersand

Ampersand (&) is used to tell Excel that it should add text together to create a new text value.

Method 3 – Easy Peasy

If remembering all these functions and formulas and where to put the quotes and what quotes to put is too much for you, you can combine multiple cells in yet another way. This one is so simple, that you simply don’t have to remember anything at all – except typing.

ALSO READ:  Macro to Concatenate Columns in Excel 2010

1. Click inside the cell where you want to enter the combined text.

2. Type the combined text. So in cell F2, I’ll type Ms. Alexis John. In cell F3, I’ll type Ms. Lori Binaj. In the next cell, when i set out to type the next name, Excel will prefill the results for the rest of the data in my column and show me the preview of that result.

By writing the combo

3. Just hit Enter or click outside the cell to accept the preview.

This method is by far the easiest as we get Excel to do all the work for us without using any formula or function.

Learn more cool Excel tips and tutorials by checking out all the posts in our archives section.

Tweet7
Share2
WhatsApp
Pin
Buffer
9 Shares

Filed Under: How To Tagged With: excel how to

You May Also Like

Ways to Use Excel Mobile - TATFI
10 Creative Ways to Use Excel Mobile in your Business
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Get Rid of the Paste Options Menu in Word, Excel and PPT
How to Calculate Number of Days Between Two Dates in Excel
How to Calculate Number of Days Between Two Dates in Excel

About Adeline Gear

Adeline is a tech enthusiast who loves exploring the latest tools and applications in the marketplace. She also loves her Android and spends time reviewing apps and playing games when she has the time.

Reader Interactions

Leave a Reply Cancel reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Hottest New Gadgets!

Best Luggage Tags for the Constant Traveller - TATFI

Best Luggage Tags for the Constant Traveller

Amazfit Band 7 - TATFI

Keep Track of Your Physical Activity with Amazfit Band 7 (Just $50)

Best Wireless Headphones to Buy in 2022 - TATFI

The Best Wireless Headphones to Buy in 2022

HyperX DuoCast USB Microphone - TATFI

Need New Microphones? Take a Look at the Fabulous HyperX DuoCast USB Microphone

Xiaomi Smart Band 7 - TATFI

Xiaomi Smart Band 7 Launches with Always On Display in 6 New Colors

Popular Tags

android android apps android games android how to apple casino games chrome extensions excel excel how to facebook gaming gmail google instagram ios apps ios games ios how to ios tips ipad iphone kids apps learn excel management microsoft music apps new releases outlook how to photo apps powerpoint powerpoint how to productivity Samsung security smartphone smartphones software tablet tablets technology twitter web browsers windows 10 word how to xbox youtube

Disclosure

TheAppTimes is a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.

TheAppTimes © 2022 // Runs on StudioPress