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 included, R84 & AC84. This is the current function I have in the cell now and as you can see it is not giving me the required output. For some reason it is not including the Value "12". Could anyone please help me with this irritating issue.

Hi Ruya16 =R84 & " off " & AC84 & " m length"

Copper Contributor

Oct 17, 2023

Solved

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 included, R84 & AC84.

This is the current function I have in the cell now and as you can see it is not giving me the required output. For some reason it is not including the Value "12".

Could anyone please help me with this irritating issue.

excel

Formulas and Functions

office 365

training

Lorenzo
Oct 17, 2023
Hi Ruya16

=R84 & " off " & AC84 & " m length"

Lorenzo
Silver Contributor
Oct 17, 2023
Hi Ruya16

=R84 & " off " & AC84 & " m length"
- Ruya16
  Copper Contributor
  Oct 17, 2023
  Thank you so much! such a simple thing and I couldn't even figure it out 😕
  - 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"

Forum Discussion

Trying to combine two text function (Two cells)

Share

Resources