Filord is a powerful Excel utility designed to save you time and effort on routine tasks - find unique and duplicate values, reverse order of rows, get subtotals and more. Free installation, seven built in functions, no learning and skills required – get your issue solved in 15 minutes from now on.
Download (1.5 Mb)
Excel Formulas and Tutorial
JOIN TEXT COLUMNS
Simple Excel technique used to merge two text columns. Concatenation operator is an ampersand - "&".Use it If you have a database with two columns where you want to merge columns A and B into a single column.
The basic formula will look like:
=A1&B1
This will give you the result shown in C1 below:
=A1&B1
This will give you the result shown in C1 below:
What we need now is to add "space" between "John" and "Smith". To do that just insert &" "& between "A1" and "B1" in your formula, so the final formula will look like:
=A1&" "&B1
=A1&" "&B1
Now we have two cells merged with a space between data.
Actually you can insert any text in 'quotes' and it will be displayed in a cell
Actually you can insert any text in 'quotes' and it will be displayed in a cell
home > join text