SOLVED

# Trying to combine two text function (Two cells)

Copper Contributor

# 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".

3 Replies
best response confirmed by Ruya16 (Copper Contributor)
Solution

# Re: Trying to combine two text function (Two cells)

Hi @Ruya16

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

# Re: Trying to combine two text function (Two cells)

Thank you so much! such a simple thing and I couldn't even figure it out :\

# Re: Trying to combine two text function (Two cells)

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

``=R84 & " off " & TEXT(AC84,"0") & " m length"``
1 best response

Accepted Solutions
best response confirmed by Ruya16 (Copper Contributor)
Solution

# Re: Trying to combine two text function (Two cells)

Hi @Ruya16

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