SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-1959399%22%20slang%3D%22en-US%22%3EInsert%20simbols%20and%20another%20values%20in%20high%20quantity%20of%20cells%20already%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959399%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20processing%20some%20data%20on%20excell.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%202%20874x12%20(rows%20x%20columns)%20tables%20of%20the%20same%20samples%2C%20and%20i%20want%20to%20add%20the%20values%20from%20table%202%20of%20the%20same%20sample%20to%20table%201%20with%20one%20simbol%20between%20the%20values.%3C%2FP%3E%3CP%3EBoth%20tables%20have%20the%20values%20in%20this%20fromat%20%221.346172908%22%20and%20i%20used%20the%20function%20(decrease%20decimal%20places)%20to%20present%20like%20this%20%221.3%22.%3C%2FP%3E%3CP%3EThe%20final%20cell%20format%20that%20i%20want%20is%20%221.3%20%2B%200.9%22.%3C%2FP%3E%3CP%3EBeing%20%221.3%22%20the%20value%20from%20table%201%2C%20%220.9%22%20from%20table%202%20and%20add%20the%20%22%2B%22%20simbol.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%3F%20I'm%20struck%20in%20this%20because%20i%20don't%20know%20how%20to%20do%20it%20in%20few%20steps%2C%20otherwise%20i%20will%20do%20it%20cell%20to%20cell...%20and%20spend%20several%20hours.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1959399%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAdmin%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959418%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20simbols%20and%20another%20values%20in%20high%20quantity%20of%20cells%20already%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959418%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892118%22%20target%3D%22_blank%22%3E%40DanielR7%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20the%20%26amp%3Boperator%2C%3C%2FP%3E%3CP%3E%3DA1%26amp%3B%22%20%2B%20%22%26amp%3BB1%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22operator.png%22%20style%3D%22width%3A%20468px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238016i9925FB057E659608%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22operator.png%22%20alt%3D%22operator.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959616%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20simbols%20and%20another%20values%20in%20high%20quantity%20of%20cells%20already%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959616%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F87534%22%20target%3D%22_blank%22%3E%40Jihad%20Al-Jarady%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20the%20answer!%20It%20works%20well%2C%20but%20when%20i%20do%20that%20i%20can't%20use%20the%20function%20to%20reduce%20decimal%20places.%20I%20get%20the%20two%20values%20and%20the%20simbol%2C%20but%20with%20long%20numbers.%20You%20know%20why%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22DanielR7_0-1607212336353.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F238051iDEC621C64F4B5E46%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22DanielR7_0-1607212336353.png%22%20alt%3D%22DanielR7_0-1607212336353.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1959619%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20simbols%20and%20another%20values%20in%20high%20quantity%20of%20cells%20already%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1959619%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892118%22%20target%3D%22_blank%22%3E%40DanielR7%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20because%20you%20need%20to%20define%20a%20cut-off%20point%20for%20the%20decimals.%20Your%20adjusted%20formula%20would%20be%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3DROUND(P6%2C1)%26amp%3B%22%20%2B%20%22%26amp%3BROUND(AJ3%2C1)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1960551%22%20slang%3D%22en-US%22%3ERe%3A%20Insert%20simbols%20and%20another%20values%20in%20high%20quantity%20of%20cells%20already%20with%20values%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1960551%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F892118%22%20target%3D%22_blank%22%3E%40DanielR7%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnother%20option%20is%20to%20use%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.microsoft.com%2Fen-us%2Foffice%2Ftext-function-20d5ac4d-7b94-49fd-bb38-93d29371225c%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3ETEXT%20function%20-%20Office%20Support%20(microsoft.com)%3C%2FA%3E%26nbsp%3B%2C%20with%20it%20you%20may%20apply%20any%20desired%20format%20to%20numbers.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.