Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data in two cells into a third cell
In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to
get cell A3 to show the result 9-0001? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data in two cells into a third cell
try this
in A3 put this =A1&"-"&A2 On Sep 25, 10:28*am, ordnance1 wrote: In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to get cell A3 to show the result 9-0001? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data in two cells into a third cell
"ordnance1" wrote:
In cell A1 is a number(9), in cell A2 is a number (0001). Is there any way to get cell A3 to show the result 9-0001? Try in A3: =A1&"-"&TEXT(A2,"0000") -- Max Singapore http://savefile.com/projects/236895 Downloads:18,100 Files:360 Subscribers:56 xdemechanik --- |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
combine data in two cells into a third cell
in A3 put this =A1&"-"&A2
... but if A2 actually contained an underlying value: 1 then the result in A3 would be: 9-1 ? OP's poser is a tricky one -- Max Singapore http://savefile.com/projects/236895 Downloads:18,100, Files:360, Subscribers:56 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do i combine 2 cells contain date in one cell, | Excel Worksheet Functions | |||
How to Combine Cells using Other Cell | Excel Worksheet Functions | |||
Combine text data from 2 cells | Excel Discussion (Misc queries) | |||
How to combine 2 cells' data into 1 cell? | Charts and Charting in Excel | |||
How to combine 2 cells' text into 1 cell | Excel Discussion (Misc queries) |