Worksheets - Manually entering text to cell already containing calculation

[unearthed]

Have looked all over for this to no avail. 

 

How do I add manually text to a cell which has data from a function call?

 

So I have a cell B65 that has text in it

 

In cell B91 I have =B$65, which gives me my text:  Planting poly     How_do_I_add_text_to_the_cell_?

 

update  - I've just found that

=concat(B$65, ref_to_text_in_Another_Cell) works, but if that cell has nothing in it function returns 0, and adds that to the result

Planting  poly0 - oh and you've got to put a leading space in your other cell or it joins the result!

 

So does one avoid that 0?

 

Haven't found any manual entry solutions though...

 

Edited November 29, 2021 by unearthed
self answering

[Pat Stanford]

=Concat(B%65, If(C2=0,'', C2))

 

The IF statement says that is the value in C2 is zero (cell is blank), then return and empty string (two single quotes next to each other) otherwise return the value in cell C2.