Excel Tutorial Library header
borderJoining cells together with Carriage Returnsborder
border Added to Library on 23 Jun 2007
Length: 5 mins

View Tutorial Movie
Download File Used



Excel has some great features for joining text from two or more cells together but these features can be a bit tricky if you do not know the tricks. This tutorial shows how to easily join cells together and covers two additional advanced features :-

1) How to use IF statements to change how the text is joined together.
2) How to use carriage returns (line feeds) to make your text appear on more than one line in a single cell.

The tricks in this tutorial can save you hours of formatting problems ...



Feedback for this tutorial:
"If I had known how to do this 2 years ago it would have saved me hours of work and a lot of MONEY ! But much wiser now - thank-you once again Clayton !"

borderborder