| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
text and formulas in the same cell
can I enter text as part of an excel formula, eg: xxx boxes
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
text and formulas in the same cell
Yes, just put it in quotes. Somthing like:
=a1&" boxes" You can also set up a custom format to achieve the same thing. If you want to format the way A1 appears, use something like: =text(a1,"0.00")&" boxes" Regards Fred. "barkingmad" wrote in message ... can I enter text as part of an excel formula, eg: xxx boxes |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| FORMULAS IN CELLS APPEARING AS TEXT IN THE CELL | Excel Discussion (Misc queries) | |||
| Add text to cell formulas? | Excel Worksheet Functions | |||
| Cell references in formulas become text | Excel Discussion (Misc queries) | |||
| formulas using text | Excel Worksheet Functions | |||
| text and numbers same cell and formulas still work (like lotus) | Excel Worksheet Functions | |||
Hybrid Mode
