| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Spreadsheet won't let me merge cells. plse help. | Excel Discussion (Misc queries) | |||
| How do I merge two cells but keeping all contents in Excell? | Excel Discussion (Misc queries) | |||
| Excel should have the option to merge contents when merging cells. | Excel Discussion (Misc queries) | |||
| check if 2 cells are equal but only if they contain numbers not i. | Excel Worksheet Functions | |||
| How can I merge unlocked cells in a worksheet that has been protec | Excel Discussion (Misc queries) | |||
Threaded Mode
