Placing text and formula together

%3CLINGO-SUB%20id%3D%22lingo-sub-2759557%22%20slang%3D%22en-US%22%3EPlacing%20text%20and%20formula%20together%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2759557%22%20slang%3D%22en-US%22%3EHi%20everybody%2C%20I%20have%20a%20problem%20regarding%20putting%20formula%20and%20text%20together%2C%20a1%2Cb1%20cell%20carrying%20two%20dates%2028march%2021%20and1%20sep%2021%3B%20c1cell%20carrying%20%3Dyearfrac(a1%2Cb1)*12%2C%20which%20results%205%3B%20d2%20cell%20given%20%3D%22year%22%26amp%3Bc1%20which%20results%20%22years5.1%22%2Cie%20not%20identical%20to%20c1which%20is%20%3CA%20href%3D%22https%3A%2F%2Ft.co%2FH8PeRfIVXu%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Ft.co%2FH8PeRfIVXu%3C%2FA%3E%20can%20it%20be%20solved%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2759557%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20Scripts%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETraining%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New 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")