Duplicate cell contents in another cell

[dsouth]

I have a list of sales something like this:

Name Chocolate Vanilla Caramel Strawberry
John Doe 2 1
Jane Smith 1 1
Jerry Long 1 1 2

At the end of the row of numbers, I have an IF formula that says if there is a number in a column, add text in that cell that says the flavor name "(=IF B2>0,"Chocoalte","")"

Is there a way to get the number in that cell before the words? i.e. 2 Chocolate

Thank you!

[Palmetto]

Is there a way to get the number in that cell before the words? i.e. 2 Chocolate

=IF B2>0,B2 & " Chocolate","")

[jhall68w]

B2 = "#" i.e. 2
B3 = Formula i.e. result = "Chocolate

Then your formula to combine them is: (enter in any other cell)

=B2&" "&B3