Combine text from two cells into one

Excel

When you need to combine two cells into one, there’s no need to cut and paste every cell. With this simple formula, you can do it quickly and accurately. 

More tech tips

Excel

Always see the headings when scrolling
Find out more ➝

Excel

Easily zoom in and out
Find out more ➝

Excel

Get to the top row without scrolling
Find out more ➝

Excel

Instantly see all data in columns & rows
Find out more ➝

Excel

Speed up typing
Find out more ➝

Excel

Do super-fast sums without formulas
Find out more ➝

Excel

Turn numbers into money with one click
Find out more ➝

Excel

Save time adding new columns or rows
Find out more ➝

Excel

Create ranges of data without doing any typing
Find out more ➝

Excel

Swap rows into columns and vice versa
Find out more ➝

Excel

Make dull data stand out and become dynamic
Find out more ➝

Excel

Insert live Excel data into Word
Find out more ➝

Excel

Make a drop-down list to select from
Find out more ➝

Excel

Understand your data with super-fast graphs
Find out more ➝

Excel

Combine text from two cells into one
Find out more ➝
View more