Excel formulas with text?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

The contents of cell A1 are numeric, say 199. I would like the contents of
cell D5 to be the contents of cell A1 concatenated with some text, like so:

A1: 199
D5: 199 days

I tried entering this as a formula for Cell D5, but it didn't work:

=$A$1 + ' days'

I'm not looking for a VBA solution, but would prefer something I can do
directly in Excel.

Any ideas?

Thanks,

Scott
 

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 to use the rownumber of the current cell in a formula 3
Adding cells but leaving blank if not populated 1
Formula not working 4
Concatenate or not? 4
Rounding down with a calculation 3
Summing from multiple wksts - incomprehensible #VALUE error 7
How do I sum cells that have values from a text formula? 4
Lookup text in a string with wildcard and return a certain value 4

Back
Top