concatenate 2 different values

System

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

Carrie Tedesco

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.

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

Try this ...

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