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?

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?

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

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