ALT + ENTER (creates a carriage return within a cell) - Excel

ALT + ENTER creates a carriage return within a cell to display information on another line within that one cell

& [ampersand] - Excel

Concatenates cells contents

Type:   =A1&B1
e.g.      =firstname&lastname
                       JoeBlogs

 

Text can be inserted into the formula by using speach marks" - "

Type     =A1&" - "&B1

e.g        =firstname&" - "&lastname

                          Joe - Blogs