Combining Text with Formula

  • Thread starter Thread starter DebraAnn
  • Start date Start date
D

DebraAnn

Is is possible to have a cell contain text information and
then a lookup to another cell.

For instance:

"The age of this person is " plus the result of another
cell that calculates his age so that cell would read:

"The age of this person is 72."

Thanks for any help you can give me.

DebraAnn
 
DebraAnn, yes.

=The age of this person is "&B1&"."

where B1 holds the calculation.
 
=The age of this person is "&A2&"."

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
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

How do I calculate a person's age from date of birth and a date 2
Can you combine if and vlookups? 3
date formulas 9
Help needed 0
Combining Text From Cells 3
Entering Days360 in Table formula 2
Calculate age 3
Calculate Age 5

Back
Top