View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default 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?