Placing text and formula together

Copper Contributor
Hi everybody, I have a problem regarding putting formula and text together, a1,b1 cell carrying two dates 28march 21 and1 sep 21; c1cell carrying =yearfrac(a1,b1)*12, which results 5; d2 cell given ="year"&c1 which results "years5.1",ie not identical to c1which is https://t.co/H8PeRfIVXu can it be solved?
1 Reply

@Bumba65464 Try this:

="year "&TEXT(C1,"0")