CODEWITHSUNDEEP
excelexcel-2013
zigojacko
zigojacko

Reputation: 2063

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.

Upvotes: 0

Views: 10048

Answers (2)

Jerry
Jerry

Reputation: 71538

Barry's answer is perfectly right. An alternate to this is using the CONCATENATE() function:

=CONCATENATE(BT742, " - ", AT742)

Upvotes: 2

barry houdini
barry houdini

Reputation: 46341

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

=BT742 & " - " & AT742

Upvotes: 4

Related Questions