concatenate 2 different values

Options
This discussion was created from comments split from: How to concatenate two functions in a single cell.

Answers

  • Carrie Tedesco
    Options

    How can I concatenate 2 different values? The (+) or Join will not work in this case. Trying to concatenate 100 and 878 to be "100878".

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Carrie Tedesco

    You can use + to add together those two numbers, but also add in "" to have the numbers read as text (instead of as numbers). This will then link them together in order, instead of creating a SUM of the two values.

    Ex:

    =[First Value]@row + "" + [Second Value]@row

    Keep in mind that this would create a string instead of a number, so then you wouldn't be able to SUM or AVG the output. If this won't work for you, it would be helpful to know a bit more about your process: what the two numbers are and why they need to be linked, then what the purpose of that linked value is.

    Cheers!

    Genevieve

  • Ramzi K
    Ramzi K ✭✭✭✭✭
    Options

    Try this ...

    =SUBSTITUTE((<cell containing 100>+ "." + <cell containing 878>, ".", "")

    Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)

    Feel free to email me: ramzi@cedartreeconsulting.com

    💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!