SOLVED

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

New Contributor

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.

 

 

7 Replies

Hi @DanielR7 

 

You can use the &operator,

=A1&" + "&B1

 

operator.png

 

@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?

 

DanielR7_0-1607212336353.png

 

best response confirmed by DanielR7 (New Contributor)
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)

 

@DanielR7 

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

@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

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

 

@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.