Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text plus formula
Is there a way to have a formula and some text after the formula in the same
cell? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text plus formula
If you mean text that shows in the cell then something like:
=SUM(A1:A20)&" Total of Column" if you mean text that will not show in the cell then something like: =Sum(A1:A20)+N("This is an explantion of what the formula does") -- HTH Sandy In Perth, the ancient capital of Scotland and the crowning place of kings Replace @mailinator.com with @tiscali.co.uk "Beep Beep" wrote in message ... Is there a way to have a formula and some text after the formula in the same cell? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Text plus formula
Like this
=A1+A2 & " My formula adds up A1 and a2" Mike "Beep Beep" wrote: Is there a way to have a formula and some text after the formula in the same cell? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nested formula to search a text string and return specific text | Excel Worksheet Functions | |||
Formula Text String: Formatting Text and Numbers? | Excel Discussion (Misc queries) | |||
Link to text and return text into a formula? | Excel Worksheet Functions | |||
Excel:Get concatenated text to be recognised as formula not text? | Excel Discussion (Misc queries) | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) |