two cell values in one cell...

Posted by Tester on September 28, 2000 2:31 AM

Can anyone help me with this simple problem?

Cell A1=500mm

Cell A2=Ø60

Cell A3=A1 A2 (500mm Ø60)

Thanks....

Posted by Andrew Lovatt on September 28, 2000 2:42 AM

Put in A3 something along the lines of:

=A1& " " &A2 & "(" &A1 & " " & A2 & ")"

Posted by Erica on September 28, 2000 2:45 AM

in cell A3 type: =A1 & " " & A2
It should work.