SOLVED

New Contributor

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

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

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

You can use the &operator,

=A1&" + "&B1

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

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?

best response confirmed by DanielR7 (New Contributor)
Solution

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

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)``

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

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

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

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

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

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

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

Hi there,

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

Please also note attached file .