| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Import plain text with formulas into Excel | Excel Discussion (Misc queries) | |||
| excel formulas with text | Excel Worksheet Functions | |||
| I want Excel to allow cells with formulas and unrelated text | Excel Discussion (Misc queries) | |||
| colored text in Excel formulas | Setting up and Configuration of Excel | |||
| How do a convert a "text only (no formulas)" Excel (.xls) file to. | Excel Discussion (Misc queries) | |||
Threaded Mode
