How do I merge 2 cells to 1 when contents are numbers
=CONCATENATE(TEXT(A1,0),"/",TEXT(B1,0))
"Sloth" wrote:
sorry, I should have read more clearly. I don't think this will be much help
to you.
"Sloth" wrote:
=A1&"/"&A2
"traceyclarity" wrote:
IThe formula for vconverting two text cells into 1 cell does not work on
numbers. I want to convert 2 cells into 1 cell for example currently cell1 is
666 and cell 2 is 333 I want the cell to look like this 666/333 (excel 2003)
|