Forum Discussion

Ruya16's avatar
Ruya16
Copper Contributor
Oct 17, 2023

Trying to combine two text function (Two cells)

Hi Everyone,   I am trying to write a function for a cell (in Column " Comments" that will give me an output " 2 off 12 m Lengths". For this function, there are two cells for the text to be include...
Excel
Formulas and Functions
office 365
training
  • Lorenzo's avatar
    Lorenzo
    Oct 17, 2023

    Hi Ruya16 

     

    =R84 & " off " & AC84 & " m length"
Lorenzo's avatar
Lorenzo
Silver Contributor
Oct 17, 2023

Hi Ruya16 

 

=R84 & " off " & AC84 & " m length"
Ruya16's avatar
Ruya16
Copper Contributor
Oct 17, 2023
Thank you so much! such a simple thing and I couldn't even figure it out 😕
  • Lorenzo's avatar
    Lorenzo
    Silver Contributor
    Oct 17, 2023

    Ruya16 

    You're welcome. You were not far. Your mistake was TEXT(AC84,""). The fix is:

    =R84 & " off " & TEXT(AC84,"0") & " m length"

Resources