add a number to text
 

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

add a number to text
 

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)

"MillyD" wrote in message
...
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

add a number to text
 

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

=A1 & B1

MillyD wrote:

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

add a number to text
 

Cheers........


"Bob I" wrote in message
...
assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1

MillyD wrote:

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

add a number to text
 

You're welcome, have a great day!

MillyD wrote:

Cheers........


"Bob I" wrote in message
...

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

=A1 & B1

MillyD wrote:


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