ExcelBanter - How do I merge 2 cells to 1 when contents are numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I merge 2 cells to 1 when contents are numbers (https://www.excelbanter.com/excel-discussion-misc-queries/67826-how-do-i-merge-2-cells-1-when-contents-numbers.html)

traceyclarity

How do I merge 2 cells to 1 when contents are numbers

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)

Sloth

How do I merge 2 cells to 1 when contents are numbers

=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)

Sloth

How do I merge 2 cells to 1 when contents are numbers

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)

dlw

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)

All times are GMT +1. The time now is 07:01 PM.