The CONCATENATE function lets you add text strings into one single text string. The function has been replaced by the CONCAT function in Excel 2016, although it still exists for compatibility with earlier Excel versions.
The CONCATENATE function may be removed in a future Excel version, I recommend you use the CONCAT function or the more advanced TEXTJOIN function instead.
Formula in cell D3:
=CONCATENATE(B3,B4,B5,B6)
You cannot use a cell range as an argument, only cell references to single cells are allowed.
Press and hold the CTRL key to quickly select multiple cells while entering arguments in the CONCATENATE function.
Excel Function Syntax
CONCATENATE(text1, [text2])
Arguments
| text1 |
Required. The argument can be a text value, number, or cell reference. |
| [text2] |
Optional. You can have up to 255 additional text strings to join. |
Comments
The new TEXTJOIN function is a lot more versatile and easier to use, however, it is only available in Excel 365.
There is a workaround available for earlier Excel versions:
Concatenate cell values
Joining multiple cell values in Excel is not easy, for example, the CONCATENATE function allows you to only reference a […]
Concatenate cell values
The following article has a formula that contains the CONCATENATE function.
The CONCATENATE function function is one of many functions in the 'Text' category.
Converts full-width (double-byte) characters to half-width (single-byte) characters.
Converts a number to the corresponding ANSI character determined by your computers character set.
Deletes the first 32 nonprinting characters in 7-bit ASCII code in your argument.
Returns the corresponding number for the first character based on your computers character set. (PC- ANSI)
Concatenates values from multiple cells.
Joins text strings.
Checks if two values are precisely the same, it returns TRUE or FALSE. The EXACT function also considers upper case and lower case letters.
Returns the position of a specific string in another string, reading left to right. Note, the FIND function is case-sensitive.
Extracts a specific number of characters always starting from the left.
Returns the number of characters in a cell value.
Converts a value to lower case letters.
Returns a substring from a string based on the starting position and the number of characters you want to extract.
Repeats a specific text a chosen number of times.
Extracts a specific number of characters always starting from the right.
Returns the number of the character at which a specific character or text string is found reading left to right (not case-sensitive)
Replaces a specific text string in a value. Case sensitive.
Returns a text value if the argument is a text value.
Converts a value to text in a specific number format.
Extracts a string after a specific substring in a given value.
Extracts a string before a specific substring from a given value.
Combine text strings from multiple cell ranges.
Splits a string into an array based on delimiting values.
Deletes all blanks or space characters except single blanks between words in a cell value.
Calculates a character based on a Unicode number.
Returns a Unicode number based on a character.
Converts a value to upper case letters.
Converts a text string that represents a number to a number.
How to comment
How to add a formula to your comment
<code>Insert your formula here.</code>
Convert less than and larger than signs
Use html character entities instead of less than and larger than signs.
< becomes < and > becomes >
How to add VBA code to your comment
[vb 1="vbnet" language=","]
Put your VBA code here.
[/vb]
How to add a picture to your comment:
Upload picture to postimage.org or imgur
Paste image link to your comment.
Contact Oscar
You can contact me through this contact form