MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.