HomeApplicationOffice information

How to concatenate strings in Excel

When working with strings in Excel, you will probably need to join strings together at a time. If you do not know how to concatenate strings in Excel, then you should refer to the ways of joining strings in Excel that the article shares below.

How to concatenate strings in Excel Picture 1

The following article shows you two ways to concatenate strings in Excel: using the & operator and concatenating strings using the CONCATENATE function.

Method 1: Concatenate strings using the & operator

How to use the & operator to concatenate strings, you can enter the text directly as follows:

= "TipsMake" & ". vn"

Your results will be:

How to concatenate strings in Excel Picture 2

You can also concatenate strings in reference cells that contain the following string:

= C8 & D8 & E8

How to concatenate strings in Excel Picture 3

In addition, you can append spaces to text strings, for example:

= C8 & "" & D8 & "" & E8

How to concatenate strings in Excel Picture 4

Or you can add special characters to the string as follows:

= B6 & "@" & "gmail.com"

How to concatenate strings in Excel Picture 5

Method 2: Concatenate strings using the CONCATENATE function

The CONCATENATE function is a concatenated function in Excel, let's learn how to concatenate using the CONCATENATE function below.

Syntax

= CONCATENATE (text1, [text2], .)

Where: text1 is a required argument, is the first string to be paired, it can be text values, numbers or cell references.

text2 is an optional argument, being the second string to pair can have up to 255 entries (8192 characters).

Note

  1. Strings are text, special characters, dates, etc., you need to enclose them in quotes, '' if the number is not in quotation marks.

For example

  1. Use the CONCATENATE function to concatenate text strings and numbers.

How to concatenate strings in Excel Picture 6

  1. Use the CONCATENATE function to concatenate strings with cell references

How to concatenate strings in Excel Picture 7

  1. Use the CONCATENATE function to concatenate strings and add spaces between concatenated strings.

How to concatenate strings in Excel Picture 8

  1. Use the CONCATENATE function to concatenate strings and add special characters to the string.

How to concatenate strings in Excel Picture 9

Above are the ways to concatenate strings in Excel that you can perform quickly. If you need to concatenate strings in Excel, you can choose one of two ways that the article guides to concatenate strings. Good luck!

5 ★ | 1 Vote

You should read it

May be interested

  • Text and string processing functions in ExcelText and string processing functions in Excel
    in excel, there are many groups of functions to help you process data quickly, one of which is a group of functions for processing text and strings. the following article summarizes the text processing functions and strings in excel.
  • MID and MIDB functions to cut strings in ExcelMID and MIDB functions to cut strings in Excel
    the mid () function returns a string from a text string, with the position to start extracting from the text string and the number of characters returned by the string that is specified. functions used in languages ​​use a single-byte character set (sbcs) and always count each character as 1.
  • SUBSTITUTE function - The function replaces text strings in ExcelSUBSTITUTE function - The function replaces text strings in Excel
    in the course of working you have excel data file need to change a series of data over the years. with a simple operation, you can change all that data. the following article details the substitute function - the function replaces the text string in excel.
  • How to combine 2 columns Full name in Excel does not lose contentHow to combine 2 columns Full name in Excel does not lose content
    in excel, to be able to merge content in 2 columns into a single column without losing content, we need to use calculation functions.
  • How to use MID functions to get strings in ExcelHow to use MID functions to get strings in Excel
    mid function in excel is a function that takes the middle character string corresponding to the value that the user requires to perform.
  • How to Manipulate Strings in JavaHow to Manipulate Strings in Java
    strings are sequences of characters. for example, 'hello!' is a string because it is made up of the characters 'h', 'e', 'l', 'l', 'o', and '!'. in java, strings are objects, which means that there is a string class that has fields and...
  • LEFT and LEFTB functions - Functions for cutting strings in ExcelLEFT and LEFTB functions - Functions for cutting strings in Excel
    left () and leftb () are two string-cutting functions that are used a lot in string processing with excel spreadsheets. the left () and leftb () functions help you cut the string to the left of the text string as quickly and efficiently as possible.
  • Normalize string when pressing Enter key in ExcelNormalize string when pressing Enter key in Excel
    the following article will guide in detail how to use functions to normalize strings when pressing the enter key in excel. this function will remove spaces at the beginning and end of the line, delete two consecutive white space characters between words.
  • How to use the TEXTJOIN function in Excel 2016How to use the TEXTJOIN function in Excel 2016
    the textjoin function concatenates text from multiple ranges and / or strings, which includes a delimiter between the connected text value. if the delimiter is an empty text string, this function effectively matches the ranges.
  • Save time with these text formatting functions in Microsoft ExcelSave time with these text formatting functions in Microsoft Excel
    microsoft excel is a main application for anyone who has to work with numbers, from students to accountants. but its usefulness extends beyond a large database, it can do a lot of great things with text. the functions listed below will help you analyze, edit, convert, change text and save many hours of boring and repetitive tasks.

Office information