You need to add character code 10, like so:

=A1&CHAR(10)&B1

Hope this helps.

Pete

On Jul 24, 3:34 pm, Cat wrote:
Hello,

I need to combine two cells into one - which I can do using the ampersand
formula, however I need to insert a line break between the information in the
two cells. Would someone please be able to point me in the right direction as
to how I would do this?

Many thanks,
Catriona