Filord was designed to save your (we mean Your) time and effort on Excel® 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 the result by
Download Version 1.0 free of charge. (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