add a number to text

  • Thread starter Thread starter MillyD
  • Start date Start date
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
 
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)
 
assuming one ref box (they are called cells) is cell A1 and the other is
cell B1 then in C1 put

=A1 & B1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to add numbers in a text string 5
Counting number of days excluding certain values 3
=Text 2
Extracting numbers from string of text 2
Rank function with the CTRL D does not advance cells the way I nee 1
Require formula to search across multiple worksheets 2
using hlookup with sum/choose? 1
how do I generate a unique reference number??? 3

Back
Top