Excel concatenate functions

Excel’s CONCATENATE functions joins two or more text strings into one string.  The item can be a text value, number, or cell reference.

If you add a double quotation with a space in between ” ” then this will add a space between the texts selected on either side.

You can also add a line break in between each text string.  This is done by entering the CHAR(10) function in between each text string/argument.  You will then need to select WRAP TEXT in order to see each text on a separate line.

See how easy this is to implement this by using employee data on the example below.



Excel concatenate functions


If you like this Excel tip, please share itEmail this to someone


Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Count Text Occurrences with Excel’s SUBSTITU... What does it do?It replaces specific text in a text string i.e. Substitutes new text for old text in a text string.Formula breakdown:=SUBSTITUTE(text, old_text, new_text, )What it means:=SUBSTITUTE(This cell, From this TEXT character, To this TEXT character, )...
How To Use INDEX-MATCH Formula The VLOOKUP formula searches for a value in the first column of an array and returns a value to the right of that array.How about if you wanted to return a value to the left hand side of that array?Well, this is where the INDEX-MATCH formula comes in and gives you a helpi...
Calculate Elapsed Time in Excel When you have two points in time and you want to calculate the amount of time elapsed, then you will need to use Excel´s TEXT functionSometimes data gets dumped into Excel with the following date & time format:24/01/2015  19:48:00.Using the TEXT function and enter...
Index Match 2 Criteria with Data Validation We can use the INDEX-MATCH formula and combine it with Data Validation drop down menus to return a value based on 2 criteria.This is a little advanced so you will need to drop what you are doing and really focus.  Let's go...First we need to convert our data into an Excel...