number manipulation

drag-driver · Apr 16th, 2002, 09:10 AM

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. · Apr 16th, 2002, 09:21 AM

=(A1&B1)+0

or

=A1*10+B1

[ This Message was edited by: Mark W. on 2002-04-16 08:22 ]

Brian from Maui · Apr 16th, 2002, 09:23 AM

In C1 enter =concatenate(a1,b1)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 09:10 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	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

Apr 16th, 2002, 09:21 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=(A1&B1)+0 or =A1*10+B1 [ This Message was edited by: Mark W. on 2002-04-16 08:22 ]

Apr 16th, 2002, 09:23 AM	#3
Brian from Maui Board Regular Join Date: Feb 2002 Posts: 7,743	In C1 enter =concatenate(a1,b1)