add a number to text

M

MillyD

Help

Lets say in one ref box the is a statement (( number of days)) and in
another ref box there is a number ((10))

Is there a formula to add these together so it will show as ((number of days
10))

Cheers
 
B

Bob Phillips

Does

Val(refbox1) + Val(refbox2)

get you where you want

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
B

Bob I

assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1
 
Top