number manipulation

[drag-driver]

problem is such:
Colum a contains a digit
colum B contains a digit
These two digits need to be combined to make a number whish is stored in colum C:
example
IN A we have digit 1
IN B we have digit 2
Want colum C to contain 12

help apreciated

 

[Mark W.]

=(A1&B1)+0

or

=A1*10+B1
This message was edited by Mark W. on 2002-04-16 08:22

 

[Brian from Maui]

In C1 enter =concatenate(a1,b1)