Insert simbols and another values in high quantity of cells already with values

[DanielR7]

Hi everyone,

I'm processing some data on excell.

I have 2 874x12 (rows x columns) tables of the same samples, and i want to add the values from table 2 of the same sample to table 1 with one simbol between the values.

Both tables have the values in this fromat "1.346172908" and i used the function (decrease decimal places) to present like this "1.3".

The final cell format that i want is "1.3 + 0.9".

Being "1.3" the value from table 1, "0.9" from table 2 and add the "+" simbol.

Can you help me? I'm struck in this because i don't know how to do it in few steps, otherwise i will do it cell to cell... and spend several hours.

[#2]

Hi @DanielR7 

You can use the &operator,

=A1&" + "&B1

[#3]

@Jihad Al-Jarady 

Thank you for the answer! It works well, but when i do that i can't use the function to reduce decimal places. I get the two values and the simbol, but with long numbers. You know why?

[#4 · Accepted solution]

@DanielR7 

It's because you need to define a cut-off point for the decimals. Your adjusted formula would be:

=ROUND(P6,1)&" + "&ROUND(AJ3,1)

[#5]

@DanielR7 

Another option is to use TEXT function - Office Support (microsoft.com) , with it you may apply any desired format to numbers.

[#6]

@DanielR7 

Once you use the & operator, you change it to text.
So, If you still want to do any calculation on it, do it within the formula as Adversi mentioned

[#7]

@adversi Thanks!!! I works well and it's exactly what i want!!!

[#8]

@DanielR7 

Hi there,

Please round Function before each Cell Address:

=ROUND(B2,2)&"+"&ROUND(C2,2)

Please also note attached file .

I hope it will help you.