Search code examples
excelexcel-2013

Appending cell value with fixed text AND value of another cell

I wish to append every cell value within a column range in Excel (2013).

For example:-

Cell BT742 contains Almond Juice currently. Cell AT742 contains 8mg currently.

I wish to append cell value BT742 to be Almond Juice - 8mg.

I have got as far as this so far:-

=BT742 & " -  "

Which is working perfectly as this results in Almond Juice -

I'm just struggling on how to extend this formula to add cell value AT742 on the end of this value.

Please could someone advise of the correct formula syntax to use in this instance? Thanks.

Solution

  • You can just use & again to concatenate, e.g.

    =BT742 & " - " & AT742