Menu
Insights Training
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools
  • Home
  • Chat with Us
  • Webinars
  • Public Schedules
  • Course List
  • Clients / Class Pictures
    • 2017 Class Pics / Clients
    • 2018 Class Pics / Clients
    • 2019 Class Pics/ Clients
    • 2020 Class Pictures
    • 2021 Class Pics
    • 2023 Class Pics
    • 2024 Class Pics
  • Testimonials
  • Convert Courses to Online
  • Request for Proposal
  • Insights Online
  • Take an Assessment
  • Blog
  • Contact Us
  • OTHER SERVICES
  • Privacy Policy
  • Code Verifier
  • Blog
  • Refer and Earn
  • Admin Tools

Blog

Combining Values of Cells in MS Excel

5/15/2019

Comments

 
When you have two or more cells with values that you need to merge in one cell, there are several ways to do this in MS Excel.

Method 1: Using CONCATENATE

The CONCATENATE function is used by identifying the cells which will be combined as one.  It is simply done as seen in the image below.

You can also add other characters in the string by enclosing them inside quotation marks.  In the example below, a space is added to separate the first name and the last name.
Picture
Method 2: Using the ampersand

The ampersand (&) can also be used to combine values of cells.  The ampersand is used like an operator, acting as if a glue that combines the cells or values (inside quotation marks as well.)  The example below demonstrates how to use ampersand to combine texts.
Picture
There are new functions in Excel 2019 that can also combine texts.  Read about them here.
Comments
    View my profile on LinkedIn

    Archives

    April 2020
    May 2019
    September 2017

    Categories

    All
    Excel Functions
    Word Features

    RSS Feed

Home

Courses

Public Classes

Contact

Copyright © 2022