View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
scottydel scottydel is offline
external usenet poster
 
Posts: 23
Default Excel formulas with text?

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