Concatenate results without decimals
You might as well save yourself 3 characters...
=TEXT(A1,"0±")&TEXT(A2,"0")
--
Rick (MVP - Excel)
"Stefi" wrote in message
...
Another solution:
=TEXT(A1,"0")&"±"&TEXT(A2,"0")
Regards,
Stefi
kemp ezt *rta:
I have two results which I want to concatenate in another cell.
I do not want to have decimals with - does anybody know how to avoid this
?
My example is:
A1=23 (cell format set to 0 decimals)
A2=4 (cell format set to 0 decimals)
In formula line for B2 I set:
=A1&"±"&A2
Then cell B2 shows 23,333333±4,122343 but I like it shows 23±4
Can somebody help?
|